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, use mail merge in Word to create mailing labels.

  1. Go to Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard.

  2. Choose Labels > Next: Starting document.

  3. Select Label options, choose your Label vendor and Product number (find this on your label package), and then select OK.

  4. Select Next: Select recipients > Browse

  5. Double-click your Excel address list, and then select OK.

  6. Select Next: Arrange your labels.

  7. Choose Address block, select OK, and then select Update all labels.

  8. Select Next: Preview your labels, and then Next: Complete the merge.

  9. ´╗┐Select Print > OK, choose a printer, and then select OK

See also

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

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.