Split the recipient information into very small pieces.Giving identical names to your Excel column will help Mail Merge to automatically match the fields and save you the trouble of mapping the columns manually. The screenshot below shows a list of the Address block fields used by Word.
Mail merge word for mac print envelopes full#
For address fields, use the full words such as Address, City, State, Postal or Zip code, Country or Region.
Whatever intricate and intimidating the task may sound, it boils down to 7 basic steps.īelow, we'll take a closer look at each step using Microsoft 365 for Excel. If you've had a chance to read our Mail Merge tutorial, a larger part of the process will be familiar to you because making labels or envelopes from Excel is yet another variation of the Word Mail Merge feature. Prepare Excel spreadsheet for mail merge.
Today let's see how you can leverage this feature to mail merge and print labels from an Excel spreadsheet.
Last week we started to look into the capabilities of Word Mail Merge.
Mail merge word for mac print envelopes how to#
You will learn how to prepare your Excel address list, set up a Word document, make custom labels, print them and save for later use. The tutorial explains how to do a mail merge from an Excel spreadsheet for labels.