Word - Mail Merge for Labels

Tags Word
  1. Open blank Word document
  2. Open the Mailings tab
  3. Select Start Mail Merge > Labels
  4. Select the manufacturer and the type of label from the options in the dialog box

  1. Choose Select Recipients
  2. To import an existing Excel list choose Use an Existing List
  3. Find the Excel sheet using the File Manager

  1. Select the sheet that the list is on
  2. The words ‘Next Record’ will now be seen at the beginning of each label

  1. Choose the Edit Recipient List button
  2. In the dialog box verify that your columns are named appropriately and that the people who are supposed to have a mailing label are checked in the list. Everyone will be checked by default
     
  3. Select Address Block and make sure that the address format is correct
  4. If the address is not correct select Match Fields and make sure that all the fields you want included in the address are matched to the columns on the Excel sheet. In the example below Address 1, the default name for the street address, needs to be matched with the ‘Street’ column. Select OK when you are done.
  5. When the address looks correct, select OK
  1. Choose Preview Results to scroll through the address to make sure they are ok
  2. Click Update labels to have all the labels shown
  1. Select Finish and Merge > Print Documents

  1. Select your printer and choose OK
Microsoft Office Applications Support Print Article

Related Services / Offerings (2)

Microsoft Office 365
A suite of Microsoft apps, including Word, Excel, Outlook, and Teams.
Office 365 Applications
Microsoft Word, Excel, PowerPoint, and many others