Save and print

Create labels with a mail merge

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

Try it!

With your mailing addresses set up in an Excel spreadsheet, use a mail merge in Word to create labels.

Create your address labels

  1. In Word, click Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard to start the mail merge wizard.

  2. Choose Labels, and then click Next: Starting document.

  3. Choose Label options, select your label vendor and product number, and then click OK.

  4. Click Next: Select recipients.

  5. Click Browse, select your Excel mailing list, and then click Open.

  6. Make sure the First row of data contains column headers box is selected and click OK.

  7. Check your list. Drag the bottom right corner to make the dialog box bigger. Then click OK.

  8. Click Next: Arrange your labels.

  9. To add the address block, click Address block and click OK.

  10. Click Update all labels.

  11. Click Next: Preview your labels.

  12. If the text doesn't fit, press Ctrl + A to select all, right-click and select Paragraph, select the Don't add space between paragraphs of the same style box, and click OK.

  13. Click Next: Complete the merge.

  14. Click Print, click OK, and click OK again.

Want more?

Mail merge using an Excel spreadsheet

Use mail merge to create and send bulk mail, labels, and envelopes

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×