Mail merge for labels
In a mail merge, Word pulls the information from your mailing list into your label document. Making labels with mail merge can get complicated—but it basically involves four steps.
Let’s start with those four basic steps—and if at any time problems crop up or you want more information, click a link to get the details.
1. Set up a document that matches your label size
Click Mailings > Start Mail Merge > Labels.
In the Label vendors list, click the company that made the labels you’re going to print on.
In the Product number list, click the number that matches the product number on your package of labels.
2. Connect the document to your address list
On the Mailings tab, click Select Recipients > Use an Existing List if you already have a list in an Excel spreadsheet or an Access database. Or click Choose from Outlook Contacts if you want to use your Outlook contacts. If you don’t already have a list, you can type a new list in Word.
Browse to the list you want, and then click Open.
If your list’s in Excel and Word prompts you, click $Sheet1, and then click OK.
If you want to make labels for only some of the names in your list, click Edit Recipient List.
Check the names you want to add to your labels.
You can also sort or filter the list to make finding names and addresses easier. For more information about sorting and filtering a mailing list, see Sort and filter the data for a mail merge.
3. Add the names and addresses
Click Address Block.
Choose how you want the name to appear.
Tip To be sure Word finds the names and addresses in your list, click Match Fields. Check that the fields you want appear in the list. If a field you want says (not matched), click the drop-down list for that field and then click the column name that matches that column in your list. When you’ve matched all the fields you want, click OK.
Click OK, and then click Update Labels.
You can also insert a picture—for example, a logo. After you add the picture, click the Layout Options button.
Then position the picture by clicking Square or Tight. Click Update Labels to see the picture on each label.
Tip Any time you make a change—for example, adding a picture—click Update Labels to see the change applied to each label.
4. Preview and print the labels
Click Preview Results, and then click the arrows to make sure the labels look right.
If the labels have too much space between each line, select the whole address in the first label, right-click, click Paragraph, and type 0 in the Before and After boxes, and click OK. Then click Update Labels to see the change applied to each label.
Tip If the addresses looks like they’re too close to the top of the labels, click before the address in the first label, press Shift+Enter, and click Update Labels.
Click Finish and Merge, and then click Print Documents.
Print a one-page test by clicking From in the Merge to Printer box and then typing 1 and the number of labels that fit on one page. For example, if your label sheets have 30 labels on each page, type 1 and 30.
If the test page looks the way you want it, load your labels into your printer, click Print Documents again, and click All.
Save your label file for next time
When you save the mail merge document, it stays connected to your mailing list. To use the mail merge document again, open it and click Yes when Word prompts you to keep that connection. Then, if you want to change which people or items you include in the merge, click Edit Recipient List to sort, filter, and select them. For more information about sorting and filtering a mailing list, see Sort and filter the data for a mail merge.