Start the Merge
Once you have your data ready you can start the mail merge.
Open up Word and click the Mailings tab.
Click Start Mail Merge and select the type of merge you will do. In this case, I’ll select the Labels option.
When the Label Options window opens, select the manufacturer of your labels and select the product number. Double check to make sure the label size is correct and click OK.
Next, click on Select Recipients and then click Existing List.
In the Select Data Source window, browse for your Excel file and click Open.
Select your table that was created earlier and click OK.
Next, we need to build the fields that will be used in the merge. To do this, we need to make sure our columns line up properly with Word. Click the Mailings tab and select Match Fields.
Make sure each of your fields in the Spreadsheet lines up with a Word field. Just use the drop down box next to each Word field and choose a corresponding column (Figure 2). Click OK when done.
Now we need to add in the fields to our merge document. On the Mailings tab, select Insert Merge Field. Be sure to properly space out your fields by using line breaks and commas where necessary. You should have something like Figure 3 when you are done.
Now, click the Mailings tab and choose Update Labels. The rest of the labels should go from saying “Next Record” to your new format.
Click the Preview results button and verify your labels will show up correctly (Figure 4).
Once you are happy with the results, hit the Finish & Merge button and select the option you would like (print, edit or email).
That’s all there is to it. As long as you prepare your Excel spreadsheet ahead of time, the actual mail merge should go smoothly. Good luck!