office 2016 mail merge labels from excel

If you want to reposition the address or insert a picture, continue below.

A Word document will appear containing the labels.

Still on the Labels window, click the New Document button at the bottom.

To change font properties, highlight the address, right-click, and click Font.

Still on the Labels window, type the address in the address box.

Select the product number from the list, and click OK.

Click the Options button at the bottom of the window.

In the 'Print' section of the Labels window (not the Print button at the bottom), choose 'full page of the same labels.'.

Open Word and click Mailings on the menu line.

Create Page of Labels with Same Address (Return Address Labels) A. Hover your mouse over an icon and its description will appear.

Hint: to see the button descriptions on the Word ribbon, make your window as wide as possible. The cell size should match your label size. When Word creates the document containing your labels, it actually creates a table and inserts an address inside each table cell. When creating labels, Word asks for the vendor and this product number. This tutorial assumes the names and addresses will be exported from a Microsoft Outlook Contacts folder or a Business Contact Manager folder.Ī package of blank address labels usually has a product number. This is useful for business mailings or mailing of holiday cards. You may also print a page of labels containing a different address on each label. We will explain how to print this type of label. It may also be useful to print a page of address labels per customer if mailings are frequent. This is most useful for return address labels. It is quite easy to print a page of labels with the same address using Word.

There are two types of labels you can print: pages of labels containing the same address, or pages of labels where each label contains a different address. ○ Two Types of Address Labels in Microsoft Word Read our disclosure policy to learn more. ○ This tutorial contains affiliate links.

Office 2016 mail merge labels from excel