Sending Multiple Outlook Emails with Multiple Attachments Automatically

Michael Dew, a lawyer up in the Great White North, has done American legal professionals a big favor by creating a MS Excel spreadsheet which can be used to send multiple emails in MS Outlook to different recipients, with each email having different attachments. See this post on Legaltree: https://www.legaltree.ca/node/2243 .


I downloaded the spreadsheet this evening and was able to successfully use it to send out emails to different recipients with different attachments in each email.



Michael provides very detailed instructions on his site, in this YouTube video, and within the spreadsheet itself. These are the key areas in the spreadsheet you have to edit:


  1. On the right side enter a draft email between the two pink rows. Use fields entered in curly brackets to pull data from the columns listed below the second pink row.



2. These fields will have to be placed on the same rows on which the subject line and email recipients are listed on the left.



3. It's possible to enter multiple email addresses in a single cell separated with semicolons.


4. In the cells shaded in yellow at the top left below the instructions, you can list up to 3 attachments that you want to have added to all of the emails that you are sending:



5. Below list on the first row for an email, the first attachment; the command 'Send' or 'Save'; the subject line; the recipient emails; CC emails; and BCC emails in columns B to G.


6. Then on subsequent rows in column B enter the paths for additional attachments for each email. Be sure to put 'Additional attachment' in column E for additional file path for all of the attachments after the first. Leave the other columns blank.



The macros in the spreadsheet allow Excel to send commands to Outlook. But 'Outlook Object library' and 'Microsoft Scripting Runtime' must be checked off in Visual Basic. Go to Tools . . . References:



When you're ready click the green button to send (or save as a draft) each email.


The emails will be sent automatically, with each opening up and sending by itself on your PC - not in the background. You'll get a message when all of the emails have been sent.



As always, I tested out this method tonight and confirmed that it worked correctly. Michael's tool may be particularly useful in sending out subpoenas to be served via email.