Print labels for your mailing list

With your address list set up in an Excel spreadsheet you can use mail merge in Word to create mailing labels. Make sure your data is mistake free and uniformly formatted.
We will use a wizard menu to print your labels. Go to Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard.
-
In the Mail Merge menu, select Labels.
-
Select Starting document > Label Options to choose your label size. Choose your Label vendors and Product number. You'll find the product number on your package of labels. Select OK.
Tip: If none of the options match your labels, choose New Label, enter your label's information, and give it a name. Choose OK to add the new label to the Product number list.
-
Choose Select recipients > Browse to upload the mailing list. Select your mailing list table and then OK > OK.
-
Select Arrange your labels > Address block to add recipient information. Select OK. To replicate the first label, select Update all labels.
-
Select Preview your labels to edit details such as paragraph spacing.
-
Select Complete the progress. Choose Print > OK > OK to print your labels.
-
Go to File > Save if you want to save your document.
Need more?
Data sources you can use for a mail merge
To create a page of labels with graphics, see Add graphics to labels
To add barcodes to your mailing list labels, see Add barcodes to labels
-
Go to Mailings > Start Mail Merge > Labels.
-
In the Label Options dialog box, choose your label supplier in the Label products list.
-
In the Product number list, choose the product number on your package of labels.
Tip: If none of the options match your labels, choose New Label, enter your label's information, and give it a name. Choose OK to add the new label to the Product number list.
-
Choose OK.
Your document now displays a table with an outline of the labels. If you don't see the outline, go to Table Layout and select View Gridlines.
-
Go to File > Save to save your document.
-
Go to Mailings > Select Recipients, and then choose an option.
For more info, see Data sources you can use for a mail merge.
-
Select OK.
-
Go to Mailings > Insert Merge Field and select the fields to show on your labels.
-
Choose OK.
-
Format the fields in the first label so it looks the way you want the rest of your labels to look.
-
Go to Mailings > Update Labels.
-
Go to Mailings > Preview Results.
Choose Preview Results again to view, add or remove merge fields. Select Update labels when done if you make changes.
-
When the labels look the way you want, go to Mailings > Finish & Merge > Print Documents.
Tip: To review and update each label individually before printing, go to Mailings > Finish & Merge > Edit Individual Documents. When you're done, go to File > Print to print the labels.
See also
Important:
Office for Mac 2011 is no longer supported. Upgrade to Microsoft 365 to work anywhere from any device and continue to receive support.
Upgrade now
When you perform a mail merge, Word inserts the records from a data source, or recipients list, into your main document. A recipients list for a mail merge operation can be an Excel sheet, the Office Address Book, a FileMaker Pro database, a Word document, or a delimited text file.
Important: You must have an existing recipients list, such as a Word document that has addresses, to complete this procedure. For more information about how to set up a recipients list, see Create a data source for a mail merge
-
On the File menu, choose New Blank Document.
A new, blank Word document opens. This becomes your main document.
-
On the View menu, choose Print Layout.
-
On the Tools menu, choose Mail Merge Manager.
-
Under 1. Select Document Type, select Create New, and then choose Labels.
-
Under Printer information, choose the type of printer that you use.
-
On the Label products pop-up menu, click the manufacturer of your labels.
Tip: For more label products, on the Label products pop-up menu, choose Other.
-
Under Product number, select the type of label that you have, and then choose OK.
Tip: For information about the margins and other characteristics of a label, choose Details.
-
In the Mail Merge Manager, under 2. Select Recipients List, choose Get List, and then select the source for the recipients list (for example, Office Address Book).
-
On the Insert Merge Field pop-up menu, choose a field name in the list (for example, FirstName).
Word adds the field name to the Sample label box.
Tip: To return to this dialog box later, in the Mail Merge Manager under 2. Select Recipients List, choose Add or remove placeholders on labels
.
-
Repeat step 9 for each field that you want to appear in your labels.
-
After you add all the fields that you want, choose OK.
Your field names are copied into all the labels in your main document.
-
In your main document, edit the first label to add spaces, commas, and carriage returns where you want them.
-
In the Mail Merge Manager, under 2. Select Recipients List, c Fill in the items to complete your document
.
Word applies the formatting that you use for the first label to all the labels.
-
To finish your labels, do one of the following:
To |
Do this |
---|---|
Preview your labels |
In the Mail Merge Manager, under 5. Preview Results, choose View Merged Data |
Print your labels immediately |
In the Mail Merge Manager, under 6. Complete Merge, choose Merge to Printer |
Create a document that contains your merged labels that you can save |
In the Mail Merge Manager, under 6. Complete Merge, choose Merge to New Document |