How do you do a mail merge in Word 2013 for Labels?
How to Create Mail-Merged Labels in Word 2013
- In Word, press Ctrl+N to start a new blank document and then choose Mailings→Start Mail Merge→Labels.
- From the Label Vendors drop-down list, choose Avery us Letter; in the Product Number list, choose 5160 Easy Peel Address Labels; click OK.
How do I print Avery Labels in Word 2013?
With your Word document open, go to the top of screen and click Mailings > Labels > Options. (In older versions of Word, the Options setting is located in Tools at the top of the page.) Select Avery US Letter from the drop-down menu next to Label Vendors. Then scroll to find your Avery product number and click OK.
How do I do a mail merge in Word for Labels?
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.
How do I make Avery 5160 Labels in Word?
How do I mail merge from Excel to Word labels?
With your address list set up in an Excel spreadsheet, Outlook Contacts, or a new list you created, you can use mail merge in Word to create mailing labels. Go to Mailings > Start Mail Merge > Labels. In the Label Options dialog box, choose your label supplier in the Label vendors list.
How do I convert Excel to Word labels?
Connecting Your Excel Spreadsheet to Word To do so, go to File > Options > Advanced > General, and select the C*onfirm File Format Conversation* on Open option. This will automatically convert any Excel formatting into the proper Word formatting when you import mail merge labels from Excel.
How do I do a mail merge in Word for 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.