Word also has a Step by Step Mail Merge Wizard (found under the Mailings tab > Start Mail Merge button), which basically walks you through the process above. When you finish your message and are ready to create the merge, go to the Mailings tab. In addition to letters (which can be any sort of document, including certificates and coupons), you can choose emails, envelopes, labels, or directories as the document type. Open a Microsoft Word document and compose your message. For more info, see Data sources you can use for a mail merge.įor more info, see Mail merge: Edit recipients.įor more info on sorting and filtering, see Sort the data for a mail merge or Filter the data for a mail merge.Repeat this for other types of documents you'd like to use mail merge for. Click the 'Mailings' tab in the ribbon and then click 'Start Mail Merge.' In the drop-down menu, choose 'Letters' or whatever other template you want to use.

Connect and edit the mailing listĬonnect to your data source. The Excel spreadsheet to be used in the mail merge is stored on your local machine.Ĭhanges or additions to your spreadsheet are completed before it's connected to your mail merge document in Word.įor more information, see Prepare your Excel data source for mail merge in Word.

For example, to address readers by their first name in your document, you'll need separate columns for first and last names.Īll data to be merged is present in the first sheet of your spreadsheet.ĭata entries with percentages, currencies, and postal codes are correctly formatted in the spreadsheet so that Word can properly read their values. Make sure:Ĭolumn names in your spreadsheet match the field names you want to insert in your mail merge.

If the issue persists, I’d like to collect some information to further check the scenario: 1. 4) Open Word and Excel, then check if mail merge works properly. Here are some tips to prepare your Excel spreadsheet for a mail merge. 3) Press Command + Shift + G, input /Library/Preferences, remove to desktop. Answer Doug Robbins - MVP Office Apps & Services (Word) MVP Replied on NovemReport abuse Word adds M to name used for a merge field if it begins with a space or a numeral. Go to the Mailings tab and click on the tab 'Start Mail Merge ' it should be on the left side of the Mailings panel.

How to do a mail merge in word on mac