Get Mail Merge Labels With Office Xp & 2003

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.

To start, open Word and go to the Mailings tab. Click on the Start Mail Merge icon and select Labels from the dropdown menu. From here, you can choose your label vendor and product number, or select Custom to create your own dimensions. Then, select Use Existing List and browse for your Excel list.

Once your label sheet opens in Word, Click Select Recipients and Use Existing List. Browse your files to find your Excel spreadsheet and click Open. ... Click Address Block or Insert Merge Field to arrange your data how you want. Click Update Labels to make format apply to all of the labels.

If you're using Avery Design & Print, select a text box, then click Start Mail Merge under the Import Data (Mail Merge) tools. The application will help you locate your file and upload the names. Then format the labels the way you want, and you're done.

How to make address labels in Excel Organize your mailing list. ... Connect the Excel worksheet to the Word labels. ... Add mail merge fields. ... Complete the merge. ... Print your labels.

Go to Mailings > Select Recipients. Choose a data source. For more info, see Data sources you can use for a mail merge. Choose File > Save.

Mail merge lets you create a batch of documents that are personalized for each recipient. For example, a form letter might be personalized to address each recipient by name.

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.

Choose Avery standard under label options and the Avery product number. Click OK after you have chosen your label size. Click Select recipients > Browse. Select the appropriate spreadsheet file and then OK > OK.