Related topics
×
Using Microsoft 365 for the Holidays
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.
Using Microsoft 365 for the Holidays

Give: Print mailing labels

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

This year, you can avoid that awful permanent-marker smell and get all your holiday card and package labeling done in a few quick steps. Once your mailing addresses are set up in an Excel spreadsheet (see the previous video to learn how), it's a snap to get Word to create mailing labels from them.

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.

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!

×