How to Mail Merge with Attachments, Custom Subject & CC / BCC – using Word, Excel, & Outlook


Mail Merge allows you to send customized envelopes, letters, and emails. Mail Merge leverages Microsoft Word, Excel, and Outlook.

In this tutorial, learn how to mail merge WITH attachments, customize the subject, and cc or bcc others using Office 365 with the Merge Tools Add-In. Additionally, learn how to set up the default email account that you send out a mail merge with.



  1. Visit Merge Tools Add-in.
  2. Click the Download button to redirect you to the Download page.
  3. Click Download button. This will download the .zip folder containing the add-in along with supporting documentation.
  4. Open the folder where you saved the .zip folder. By default, it should be saved to your Downloads folder.
  5. Un-zip the zip folder by right clicking the MERGE TOOLS file and selecting “Extract All…”
  6. Open the un-zipped folder to see the contents.
  7. Move the “Merge Tools – 2022” Microsoft Word Macro-Enabled Template to your Word Startup f0lder.
    • You can find your Word Startup folder by the following steps:
      • Open Microsoft Word
      • Click File -> Options.
      • Select the Advanced Tab.
      • Scroll down to the General section on the Advanced tab and select “File locations…” button
      • At the bottom of the list is the Startup folder. You can click Modify to show the location.
      • Copy the file location by selecting Ctrl-C in the explorer tab.
      • Cancel out the dialogs.
    • Open File explorer and navigate to the Startup folder by pasting in the location.
    • Move the “Merge Tools – 2022” Microsoft Word Macro-Enabled Template to the Startup folder.
  8. Close and re-open Microsoft Word. (This is necessary so it can enable the “Merge Tools – 2022”.
  9. You should be able to see the Merge Tools tab on the Word ribbon.


  • Open Microsoft Word to a New Blank document.
  • Create a Mail Merge by navigating to the Mailings tab on the ribbon.
  • On the ribbon, click on “Start Mail Merge” ->”Letters”.
    (You can still send an email with this option but you will need to choose Letters as that is compatible with the Merge Tools Add-In)
  • On the ribbon, click on “Select Recipients” -> “Use an Existing List…”
  • Select the Excel spreadsheet you want to use (in this example you can use this sampe spreadsheet) to perform your Mail Merge.
    • The spreadsheet should include a column of at least emails and document locations on your computer, like this:
      Email Address Document Location C:\users\kevin\Desktop\document1.docx C:\users\kevin\Desktop\document2.docx
  • Select the Sheet in the Spreadsheet to use (probably Sheet1) and click OK to close the dialog.
  • Write the email you want to send in the Word document.
    • You can add in the column names as Merge Fields to cusomize the email message using the “Insert Merge Field” option.
  • Save the Word document.
  • Click the Merge Tools ribbon tab.
  • In the ribbon, click “Merge with Attachments” button to open the Mail Merge with Attachments dialog.
  • Add the column that contains the attachment location to the right to ensure that each email gets the custom attachment.
  • To have every email get the same attachment, add the document using the “Browse for attachments to be included with every message” and add the document that should be included for all emails.
  • Choose the Merge Destination field and choose “Merge to Email Message”
  • Select the Field containing the email to be the column name in the Excel spreadsheet with the email.
    • If you want to set a CC or BCC Addresses you can do so in the next options.
    • Select the “Data Source contains a subject field” and enter in the email subject.
  • Click Continue
  • Select All to email all users in teh Excel spreadsheet or choose


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s