Mail Merge Excel Address Labels. Now it s time to add your mail merge fields in word s labels. With the holidays fast approaching now is a good time to tackle your address list.
There should be separate columns for each of the following data. This is normally first name last name street address city county postal code. Click on the first label on the page and then select address block in the write insert fields section of the mailings tab.
Now it s time to add your mail merge fields in word s labels.
Click on the first label on the page and then select address block in the write insert fields section of the mailings tab. Step 1 prepare address list for making labels in excel. The mail merge process creates a sheet of mailing labels that you can print and each label on the sheet contains an address from the list. There should be separate columns for each of the following data.