Word closes the Label Options dialog box. Using the Label Vendors drop-down list, choose Avery US Letter. Word displays the Label Options dialog box. 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.Ĭlick Print, click OK, and click OK again. The Labels tab of the Envelopes and Labels dialog box. To add the address block, click Address block and click OK. Drag the bottom right corner to make the dialog box bigger. Make sure the First row of data contains column headers box is selected and click OK.Ĭheck your list. In Word, click Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard to start the mail merge wizard.Ĭhoose Labels, and then click Next: Starting document.Ĭhoose Label options, select your label vendor and product number, and then click OK.Ĭlick Browse, select your Excel mailing list, and then click Open. Next, you will click on cancel to close this window since you already have the template open. At this time we only support 8.5 x 11 products which are available in the US and Canada. The information in your list is merged into Avery Design & Print Online, where you can format and print your project. Once you have the template open in Word you will want to select the mailings tab at the top and then select start mail mergeSelect labels next. Avery Wizard software only works through Word 2013. The Avery Easy Merge add-in makes it quick and easy to create labels, cards and name tags using an Excel spreadsheet. Choose any one option under the Label Vendors list. 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. To merge with a downloaded template in word for PC you will need to download the template from . Find your Avery product number: Go to Mailings tab > 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |