Send Outlook Emails using Excel

Add Attachments

Send same attachments to multiple recipients or different attachments per recipient -all automated!

Multiple Recipients

Send personalized emails to hundreds of recipients at a fraction of the time -at the push of a button

Retain Formatting

Maintain the look and feel of your email body -including the email signature and font size and colour

To send Outlook emails using Excel VBA can be intimidating at first.

But…

You don’t need to know the code to start using this! Just download the file and you are good to go

Click here to download the Excel tool

Remember this:
The code on this page only works for those who use Outlook.

The video below describes how the Excel macro to send bulk emails with attachments work for these scenarios:

1. If you want to send the SAME attachments/files to ALL the recipients
2. If you want to define a set of attachments for each recipient

https://youtu.be/1ON55nxiUiw

Important Instructions:

• For the salutation cell, just type your preferred salutation (say, Dear or Hi or Hello, etc) without including the name which will automatically be picked from the names specified against the emails
• Critical -the file path name SHOULD NOT be in double quotes! (Tip: To get the path, while holding down the SHIFT key, right click on the file and choose Copy as path)
• Signature -the email signature need to be set up in your Outlook Desktop. While on Outlook, click on File >>>Options >>>Mail >>>Signatures… and then customize the signature as required