If you selected Choose from Outlook Contacts or Apple Contacts, follow these steps:.

In the Open Workbook dialog box, select the sheet you want to use, and leave Cell Range blank to use the entire worksheet or enter a cell range for the data you want to use, and then choose OK.

Browse to the file you want to use and choose Open.

If you selected Use an Existing List, follow these steps:.

On the Mailings tab, choose Select Recipients, and then choose an option.

Step 3: Link your mailing list to your labels

On the File menu, choose Save to save your document.

If you do not see the table, on the Table Layout tab, choose View Gridlines.

Choose OK to close the Layout Options box.Your document now displays a table with an outline of the labels (the dimension and shape of the labels depends on the label product you chose).

Choose OK to add the new label to the Product numberlist. Tip: If none of the options match your labels, choose New Label, enter your label's information, and give it a name.

In the Product number list, choose the number that matches the product number on your package of labels.

In the Label Options dialog box, choose your label supplier in the Label products list.

On the Mailings tab, choose Start Mail Merge > Labels.Step 2: Prepare mail document for labels. If you want to use your Outlook contacts, make sure Outlook is your default email program.If you're using an Excel spreadsheet, make sure the column for ZIP or postal codes is formatted as text so that you don't lose any zeros.

Before you start the mail merge process, collect all of your address lists. If you don’t yet have a mailing list, you can create a new list in Word during mail merge.It contains the records Word pulls information from to build the addresses for the labels. The address list can be Excel spreadsheet, a directory of contacts, either Outlook or Apple Contacts.

Use this knowledge base to generate name badges. Merges can also be used to personalize a common email sent to a group of recipients. Each label can contain addresses, or names for badges. Create mailing labels in Word by using mail merge. When you want to use labels to send a mass mailing or create name badges, you can use mail merge to quickly create a sheet of labels.

Create labels in word 2016 from excel