How to Create Mail Merged Labels
Microsoft Office 2016
What is Mail Merge?
Step 1: Create/Organize your Spreadsheet in Microsoft Excel
This information can include:
- First Name
- Last Name
Step 3: Open the Mailings Tab
Step 5: Change Label Options and Click Ok
Change the label options to the correct Vendor and Product number listed.
If you are printing to a page of 30 mailing labels, you may also choose the following universal label information if you cannot find the Vendor or Product number of your labels:
Label Vendors: Microsoft
Product Number: 30 Per Page (Height: 1", Width: 2.63")
Step 9: Click on Address Block in the Write & Insert Fields Section
Sometimes we need to correct the problems (the example below is missing the city) manually by changing some items in the Match Fields settings that is located at the bottom right.
Go through each item to see if you would like to add more field items to your Address Block.
Check Remember this matching for this set of data sources on this computer and click OK.
Below shows our corrected Address Block after manually fixing the problem. (City is now inserted.) Click OK to close Insert Address Block settings.
Step 11: Preview Results
Click the Preview Results button in the ribbon.
You should now be able to see all your information from your Excel spreadsheet on your labels.
Step 12: Fix Text Format
Customize your labels to the font and size you would like to have. Click Update Labels to automatically update all the labels to the same text format.