An VBA Solution which allows you to send out emails en masse from a spreadsheet directly in Excel via Outlook. Emails can be customised by individual and can contain attachments.
Click below to watch the walkthrough video:
The standard Template contains columsn Email, First Name, Surname, Email Body, Attachment and Subject. The Email Body
column denotes which HTML file to use as the body of the email. The Attachment
column denotes which attachments to included as part of the email.
To edit the body of the email, open the EmailBody.html
file and edit in your preferred HTML editor. In the example Emailbody, the (((First_Name))) is replace by the value as it appears in Column A of the spreadsheet. You can added further replacements like using by editing the VBA code email below.
Should you wish to add or remove columns, be sure to adjust the variable assignments to compensate fro any changes you make
When using Outlook 365, emails are limited to 30 per hour (and 10,000 per day). Should you attempt to send more than this, your account will be locked for 24 hours. In order to prevent emails being sent too rapdily, a 3 second pause occurs between each email.
Depending of your Operating systems settings, screensavers and sleep mode may prevent emails being sent. To circumvent this, the script using sendkeys to toggle numlock
. Remove this if it is not necessary for your OS configuration.