Mail Merge for MacOS


Step 1: Preparing the Email

1. Begin by opening Microsoft Word and going to Mailings > Start Mail Merge > E-mail Messages.

mail merge email

Step 2: Setting Up a Mailing List

2. Once you have completed your email message and are satisfied with the contents, go to Mailings > Select Recipients.

3. At this point, you have the option to fetch user data from an Excel file, create one on the spot, or use Outlook contacts. For most cases, Outlook contacts or Excel will be sufficient options.

Excel Tips:

  • All data to be merged is present in the first sheet of your spreadsheet.
  • Data entries with percentages, currencies, and postal codes are correctly formatted in the spreadsheet so that Word can properly read their values.
  • The Excel spreadsheet to be used in the mail merge is stored on your local machine.
  • Changes or additions to your spreadsheet are completed before it's connected to your mail merge document in Word.

4. After you have added your content and selected the recipient contact list or Excel file, you can preview your mail. Choose Preview Results, and then choose Next Next record button for mail merge preview results or Previous Previous record button for mail merge preview results to see the names and addresses in the body of your email.

Screenshot of the Mailings tab in Word, showing the Preview Results group.

5. Once you are ready to send, Choose Finish & Merge > Send E-mail Messages.

Screenshot of the Mailings tab in Word, showing the Finish & Merge command and its options.

6. In the To box, choose the email address column or field from your mailing list.

Note:  Word sends an individual message to each email address. You can’t Cc or Bcc other recipients. You can include links, but you can’t add attachments to the email.

7. In the Subject line box, type a subject line for the message.

8. Choose the To merge field, the subject, and whether to send as text, HTML, or as an attachment. When you send as an attachment, the email has no body text, but the message is sent as an attached document.

10. Select Mail Merge to Outbox.

Note: The limit of 100 external emails per hour still applies when using mail merge, please space out emails to prevent being marked as spam.

For more information on Mail Merge, how it works, and its additional uses, please read here.

Version 1.0.0 | 2023/09/20

Article Details

Article ID:
Date added:
2023-09-14 19:37:04
Rating :

Related articles