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

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.

×