Send bulk emails using Outlook (with Signatures) - Excel VBA macro tutorial

Many people asked me about how to add signatures in the emails that we send using outlook and excel VBA.
In this tutorial, I have again explained how to send emails in bulk using outlook and a script in microsoft excel. Along with that I have explained the signature part as well.

Stay connected.. Hit Like.. Subscribe to our channel and HIT th BELL icon to get updates.

[pecckfamily]

This worked perfectly. I've been searching far and wide on how to include my signature when sending out emails via a loop. The trick, as you said, was moving .Display above .HTMLBody and adding "& .HTMLBody" to the end of the line. Those simple adjustments fixed it. Bless you sir.

[Mrsbrew]

THANK YOU so much for this! It did work!

[RichardWing]

Thanks for the video. Is there a way to specify a different outlook signature than than the default? Can we use the name of the signature we gave it when making the signature? If so can I have place holders in the signature, add the signature first an loop back and add excel data in place of place holders? Basically merge dynamic data into a specific outlook signature? I use signatures as templates and manually insert the data I need to use into them depending on the situation. I am hoping to automate these processes.

[Cupids-lxxj]

can add one more column? to attach file or all files in folder

[KevinQuinn-ow]

Great video. This works; however, when you replace .Body with .HTMLBody I lose the paragraph breaks I had before. How do I fix this? For example, before you replace .Body with .HTMLBody, you had three different lines in the VBA generated email. Those would now show up as concurrently running sentences?

[sambisht]

Hi Kamal,

Your code is great. It really helps me. Now after sending a new mail through this code I want to send a mail again to same email addresses after 3-4 days as a follow up mail, whom I didn’t get the revert in the same email chain/thread after sending first mail. How will I do it? Could you please advise. Thanks

[drs]

Hi sir
Any video on task scheduler in detail as I am looking for tasks to run automatically at scheduled time which will help me in reducing some man-hours

[kirannaidu]

Hi Kamal, thanks for uploading such useful coding material. I have almost watched all of your videos and huge fan of yours now..can you pls help me if I have to send a dynamic table basis a specific criteria to individual mail id's.for ex.. performance of a partner with a body snap shot..count of the partners could be in hundreds

[sanjurathod]

Hello kamal, video found useful, however in the body of the mail, i need paste the snapshot along with signature, i tried.display before htmlbody but not able to get, please help me with this

[gillianmcnosehair]

Amazing video. Really helpful. How do I amend the body email text so it does not default to calibri, font size 11? Many thanks

[bharathisrini]

Hello Kamal, See in your demo excel you have the differnt body of the email for each Row (i.e in Column C ) you have the body for steve different, kamal differnt and for tema is different - i want to send emails at once with the same macro code with attachements but to add signature converting to .htmlbody will send only one email for at column A - Can u explain how to do add signature as default for all emails run in the Macro .
Excel - column A - "To", column B- "CC" column C - "Subject " column D- " Body" Column E- I = "multiple attachments" Column J- Status .
Below is my code .
Option Explicit

Sub Send_Mails()
On Error Resume Next
Dim sh As Worksheet
Set sh =
Dim i As Integer

Dim OA As Object
Dim msg As Object

Set OA =

Dim last_row As Integer
last_row =

For i = 2 To last_row
Set msg = OA.createitem(0)

msg.to = sh.Range("A" & i).Value
msg.cc = sh.Range("B" & i).Value
msg.Subject = sh.Range("C" & i).Value
msg.Body = sh.Range("D" & i).Value
'I need to include signature as default

If sh.Range("E" & i).Value <> "" Then
msg.attachments.Add sh.Range("E" & i).Value
msg.attachments.Add sh.Range("F" & i).Value
msg.attachments.Add sh.Range("G" & i).Value
msg.attachments.Add sh.Range("H" & i).Value
msg.attachments.Add sh.Range("I" & i).Value

End If


msg.display

sh.Range("J" & i).Value = "Sent"

Next i

MsgBox "All the mails have been sent successfully"


End Sub

[gawrangsoni]

Hello, thank you very much for sharing.
Can we sort, select and delete multiple mails through mail details on excel sheet.
Pls help on this.

[resourcedragon]

Thank you for this. Just one question, though:

"For i = 9 to Sheet1.Cells(Rows.Count, 1).End(xlUp).Row" makes sense but I've always used "Next i" and not just "Next" at the end of the For loop. Can you get away with leaving out the "i" because it's not a nested loop?

[kirtirajpoojary]

How to use the same code to add custom signature which is created in outlook apart from the one which is set to default.

[ahmedal-dossary]

Signature was not added to bottom of mail body when pasting an excel range (table for instance). Any thoughts?

[jeganraju]

I need a code for sending a multiple mails with filtered excel table is pasted in body of the email. Pls help me with this requirement

[sarunas]

Hey, thanks, I try to type .HTMLBody but signatute does not appear, I just get error invalid or unqualified reference. Any ideas why?

[jainishjain]

Hi Kamal, this video seems to be a solution for one of my automations. But, I am still getting some errors and unable to find the :Microsoft Outlook reference in the VBA. Is it different with Mac ?

[rakeshbond]

Hello Sir, I wanted to paste table from excel to mail body and mail it with default outloook signature. Any idea

[alyamcvay]

Hello,
How would you recommend skipping blank cells?