Give: Print mailing labels
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
- In Word, click Mailings >Start Mail Merge >Step-by-Step Mail Merge Wizard to start the mail merge wizard.
- Choose Labels, and then click Next: Starting document.
- Choose Label options, select your label vendor and product number, and then click OK.
- Click Next: Select recipients.
- Click Browse, select your Excel mailing list, and then click Open.
- Make sure the First row of data contains column headers box is selected and click OK.
- Check your list. Drag the bottom right corner to make the dialog box bigger. Then click OK.
- Click Next: Arrange your labels.
- To add the address block, click Address block and click OK.
- Click Update all labels.
- Click Next: Preview your labels.
- 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.
- Click Next: Complete the merge.
- Click Print, click OK, and click OK again.