How to Merge Excel List into Word Labels

Click here for video of the process

1.Create the Excel list with each field (First Name, Last Name, Address, etc.) in separate columns.  Ensure there are no blank rows in the list.  Save and close it.

2.Open a new document in Word.

3.In the ribbon, click the Mailings tab. In the Start Mail Merge group, click Start Mail Merge command dropdown. Select Labels…

4.The Label Options window opens. Select label vendor, then select label product number.  Click OK.

5.In the Start Mail Merge group, click Select Recipients command dropdown.  Select Use Existing List…

6.A browse window opens. Find and click on Excel list. Ensure the file name appears in the selection box.  Click Open.

7.A Select Table box opens. If you have multiple worksheets with data, select the list you want.  Ensure the First row of data contains column headers box is selected if it is true.  Click OK.

8.In the Write & Insert Fields group, click Insert Merge Field. In order, click the field from your list that you want to appear on the label. Click Insert. Be sure to hit Space, Comma or Enter when appropriate.  Code appears in one label.

9.In the Write & Insert Fields group, click Update Labels. Code goes into each label.

10.In the Write & Insert Fields group, click Preview Results.  The code is replaced with the data.

11.In the Finish group, click Finish & Merge command dropdown. Click Print Documents…

12.The Merge to Print dialog box opens.  Select which records to print.  Before clicking OK, ensure the labels are in your printer facing the correct way.  A Print dialog box opens. Make your selections and click OK.