Use mail merge to create a form email message in Word 2016 for Mac

If you have a letter to send to many people via email that you want personalized for each recipient, use mail merge. You can create a batch of personalized email messages that are formatted identically and use the same text. Only specific sections of the email message vary and are personalized. Mail merge—unlike broadcasting a message to a group of people—makes each recipient of the message the sole recipient.

There are three files involved in creating email messages using the mail merge process:

Your main documentThis document is your email message; it contains text that is identical for each version of the merged document.

Your mailing listThis is the data source, often an Excel spreadsheet, that is used to populate information in the email message. Your mailing list has names, for example, and your main document is the email that will be addressed to the names in your list.

Your merged documentThis document is a combination of the main document and the mailing list. Mail merge pulls the information from the mailing list and puts it in your main document, resulting in a personalized, merged document for each person on the mailing list.

The first row in your Excel spreadsheet is the header record. Each column in the row has a label name that indicates a category of information. For example, your column labels might be email address, name, street address, city, state, and postal code. Each subsequent row contains a single record of data for each recipient. There must not be any blank rows or columns in the list.

Tip: To make an Excel spreadsheet of your Outlook address book, export the contacts to a tab-delimited (.txt) file, and then open the .txt file in Excel. For more information, see Export or manually archive Outlook items.

In the first row of the Excel spreadsheet, type the column labels for your recipients. For example, in the first column, type Email address; in the second column, type First name; and in the third column, type Last name.

Important: It's recommended that the first column contains each recipient's email address.

In the second and subsequent rows, type a recipient's email address, first name, and last name.

On the File menu, choose Save, and enter a file name.

Note: Remember the location of the spreadsheet; you'll need it later to link it to your mail merge document.

Save and close the spreadsheet.

Note: You can't complete the merge if you don't close the Excel spreadsheet that contains your list, or if you reopen it before the mail merge is finished.

In the Edit List Fields dialog box, Word automatically creates fields for some basic information, such as first name, last name, and address. If you want to add a new field—for example, a message field—add it now, so you can fill in the field when you type the entry.

Under New field name, type the name of the field you want to add and then click + (plus sign).

Tip: To change the order of the fields, choose the field you want to move, and then use the up or down arrow to move the field.

When all fields are set up as you want, choose Create to make a new list.

Use an Existing List

Browse to the file you want to use and choose Open.

In the Open Workbook dialog box, select the spreadsheet you want to use, and then do one of the following:

Leave Cell Range blank to use the entire spreadsheet.

or

Enter a cell range for the data you want to use.

Choose OK.

Choose from Outlook Contacts

Choose Filter Recipients to select the recipients you want to include.