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
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:
- If you want to send the SAME attachments/files to ALL the recipients
- If you want to define a set of attachments for each recipient
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