You are here

Bulk send emails in Outlook with attachments using Excel - Freeware

Research articles : 
If you use the spreadsheet and find it useful please consider making a small donation to help cover the costs of maintaining this website.
Overview of the spreadsheet
The spreadsheet allows one to bulk send up to 1000 emails, with attachments. The ability to send attachments is the key feature that makes this spreadsheet worthwhile rather than just using the regular method of bulk sending emails using the mail merge / email merge feature of Microsoft Word. 

Beware of sending the wrong email and/or attachment to the wrong person. The spreadsheet is powerful in the sense it can send out many emails to many people at once. But that power is dangerous! It is strongly recommended to either check email attachments using the orange Preview button available in the spreadsheet, or else enter "Save" into the "Send or Save!!!" column which will cause the macro to place the emails into the "Drafts" folder in Outlook where the drafts can be reviewed before sending out. If you enter "Send" into the "Send or Save!!!" column then the emails will be sent out by Outlook when the green Send button is clicked.

Security issues
The spreadsheet was developed using macros (programmed in visual basic) and in order for the spreadsheet to operate your security settings in Microsoft Excel must be set to allow macros to run.  To enable macros in Office 365 (similar procedures will apply in other versions of Excel) click:
  • File (i.e. the menu on the top left)
  • Options
  • Trust Centre
  • Trust Centre Settings
  • Macro settings
  • Enable all macros
Macros can pose a security risk because they make your computer perform certain steps automatically, but are typically only dangerous when made to be that way by a computer programmer with a malicious intention – hence the warning when you change the security settings in Excel. However, the macros available in the spreadsheet available for download on this page are made with good intentions and will not intentionally harm your computer.
Users downloading and using this spreadsheet do so entirely at their own risk and agree to accept all risks associated with using the spreadsheet. 
The spreadsheet is open and users familiar with macros can review (and modify) the code.
Users should not edit any of the cells (or worksheet names) ending in “!!!”, these are landmarks used by the macros and editing those cell names or worksheet names will prevent the macros from working. 
The macros cause Excel to control Outlook and so require that the "Outlook Object library" is turned on. In Excel, press Alt + F11 to open the Visual Basic editor, go to "Tools", click "References", and then check the box for "Microsoft Outlook Object Library".