Video: Create labels with a mail merge in Word
Applies To
Office 2024 Office 2021 Office 2019 Office 2016This 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.