strbody

I have the following code below that includes a range name The name AutoEmail is on sheet Macro V1:V2 The name Auto_Name is in sheet Macro U1:U2 On Error Resume Next With OutMail .To = Join(Application.Transpose(Range("AutoEmail").Value), ";") .CC = ""...

I have a VBA script in an excel file that will generate an email. My problem is setting the font in the email. This code works: strbody = "****** style=font-size:11pt;font-family:Arial>Hello.</BODY>" This code does not work: strbody = "****** style=font-size:11pt;font-family:Segoe UI...

Please help. I have no clue why I'm getting an error that says 'object variable or with block variable not set" I have a userform with several textboxes, checkboxes, and radio buttons on it. They are not all required. My goal is to get the values or captions of these controls to display in...

Hello, I need help adding text to the subject line of emails that are automatically generated from a spreadsheet I am creating. Basically I just want to have the text from cell J3 entered after the "Reminder" statement. Here is what I have so far. Sub email() Dim OutApp As Object...

Hello... Can someone please help. I have a frame within a user form that contains 6 checkboxes. The user may select more than one checkbox. I am trying to send the caption of the selected checkbox(es) to the body of an email. I wrote the code below but it returned the same one twice (see the...

Greetings, I found this code online and it's not working for me :( (Outlook 2016) I have set all macros to allow in the trust center and inserted the code inside Developer-visual basic-this outlook session. ' Declare a variable to save the body content. Dim strBody As String ' Conver the...

I need a thread to send an email out with in 30 days of a date to remind of a due date using macros. Need help please. I have the email set up just need the 30 days This is what I have and it works, I just need to add 30 day string. Is this possible??? private Sub CommandButton7_Click()...

Hi guys, Good day. Can you help me on this. When I click the command button the outlook mail will automatically appear with an attachment, however I want the excel sheet on that excel file have been deleted(Sheet 1 or 2). Code: Dim OutApp As Object Dim OutMail As Object Dim...

If sheet2 , Col C , contains a value <> 0 for eg -325.65, 985.75 etc , then the text below to be excluded from being in the body of the email Strbody = Strbody & Join(Application.Transpose(Range("R3:R4").Value)) & " - please attend to these amounts " & vbNewLine & vbNewLine It would be...

Hi, So far I have been able to generate an email off the back of an Excel spreadsheet. My plan was to then save a draft of this email in the local folder so that it can be used by another user. Unfortunately I have hit a wall on this, so here I am! Copy of the VBA code can be found below. Any...

Hi there, I have a code here that sends an email to 1 person. However, i do not want to hard code the email in but instead i have a list of emails in a sheet (named: control) from cell V33:V40 here is my current code: Sub Email() Dim OutApp As Object Dim OutMail As Object Dim...