Related topics
×
Save & print
Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Save & print

Print labels for your mailing list

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

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.

  1. In the Mail Merge menu, select Labels.

  2. 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.

  3. Choose Select recipients > Browse to upload the mailing list. Select your mailing list table and then OK > OK.

  4. Select Arrange your labels > Address block to add recipient information. Select OK. To replicate the first label, select Update all labels

  5. Select Preview your labels to edit details such as paragraph spacing.

  6. Select Complete the progress. Choose Print > OK > OK to print your labels.

  7. 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

  1. Go to Mailings > Start Mail Merge > Labels.

    On the Mailings tab, Start Mail Merge and the Labels option are highlighed

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

    Select a brand of label products, and then select the specific product number.
  3. 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.

  4. 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.

  5. Go to File > Save to save your document.

  6. Go to Mailings > Select Recipients, and then choose an option.

    For more info, see Data sources you can use for a mail merge.

    On the Mailings tab, Select Recipients is highlighed with a list of options

  7. Select OK.

  8. Go to Mailings > Insert Merge Field and select the fields to show on your labels.

    On the Mailings tab, Insert Merge Field is highlighted

  9. Choose OK.

  10. Format the fields in the first label so it looks the way you want the rest of your labels to look.

  11. Go to Mailings > Update Labels.

  12. Go to Mailings > Preview Results.

    On the Mailings tab, Preview Results is highlighted

    Choose Preview Results again to view, add or remove merge fields. Select Update labels when done if you make changes.

  13. When the labels look the way you want, go to Mailings > Finish & Merge > Print Documents.

    On the Mailings tab, Finish & Merge and the Print Documents option are highlighted

    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

Create and print labels

Create a data source for a mail merge

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×