You are here

Bulk send emails in Outlook with multiple attachments using Excel (email merge with many attachments) - Freeware

Research articles : 
Donations 
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 is made available by Legaltree Law Corporation and 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.

 
Two versions available for download
Most users will want to use the newer / more advanced HTML version, but the Plain Text version shown in the video is also available for download. 
 
Plain Text version (the version shown in the video)
  • Does not allow CC or BCC.
  • Does not include any signature in messages by default. 
  • Message body can be plain text only. 
HTML version (not shown in the video, but available for download above).
  • Includes CC and BCC fields.
  • Allows bold, underline, italic formatting of text in the email body. 
  • Includes your default Outlook email signature in each message composed by the macro. 
  • Allows sending of up to three files attached to ALL emails. 
  • Allows sending of up to 30 additional files attached to each email (see further description below). 
 
Explanation of how to attach multiple files to each emails, with different files attached to each email (THIS FUNCTIONALITY IS NOT SHOWN IN THE VIDEO)
  1. Email attachments are optional i.e. you can use the spreadsheet for bulk sending emails without attachments if you wish.
  2. Each email can have up to 30 email specific attachments (in addition to the three attachments that can be attached to all emails).
  3. Enter the path to the first attachment specific to the particular email in the 'Paths' column on the same row as the other email data i.e. in the same row as the email addresses, subject line, message body variable data, etc. (see image below).
  4. Additional unique attachment paths can be listed on the subsequent rows as follows: specify the additional attachment path in the  'Paths' column and specify "Additional attachment" (without the quotes) in the 'To' column, and leave all other cells on that row blank (see image below).

Typically the data set required for the below the headings will be built on another sheet using typical Excel functionality (e.g. CONCATENATE, etc.).

Let me know if you find any bugs in the code and I will try and fix them. 

 
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".