With your address list set up in an Excel spreadsheet you can use mail merge in Word to create mailing labels. Make sure your data is mistake free and uniformly formatted.
We will use a wizard menu to print your labels. Go to Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard.
- In the Mail Merge menu, select Labels.
Select Starting document > Label Options to choose your label size. Choose your Label vendors and Product number. You'll find the product number on your package of labels. Select OK.
Tip: If none of the options match your labels, choose New Label, enter your label's information, and give it a name. Choose OK to add the new label to the Product number list.
- Choose Select recipients > Browse to upload the mailing list. Select your mailing list table and then OK > OK.
- Select Arrange your labels > Address block to add recipient information. Select OK. To replicate the first label, select Update all labels.
- Select Preview your labels to edit details such as paragraph spacing.
- Select Complete the progress. Choose Print > OK > OK to print your labels.
- Go to File > Save if you want to save your document.
Comments
0 comments
Please sign in to leave a comment.