![avery 5160 label template microsoft word download avery 5160 label template microsoft word download](https://i.pinimg.com/736x/54/fe/d0/54fed0feecd628320b9d0c83af3d4ee1.jpg)
Options for changing the template colors, fonts, text, and graphics are available after you click Create.įor more info about Publisher templates, see Create a publication from a template, Make a brochure, and Find brochure templates. Avery 8371).Ĭlick a template, and view the description to determine whether the template is designed for your Avery number. To find the most recent Avery templates online, type Avery in the Search box, or type in the Avery number (e.g. Options for changing the template colors, fonts, text, and graphics are available after you click Create. If it is, click Create to begin your publication. On the Start page, click Built-In, and choose a template category.Ĭlick a template and check the description to see if the template is designed for your Avery number (e.g. You can also get to this page by clicking the File > New. You can find Publisher templates on the Start page that appears when you open Publisher without first picking an existing file to open. If the Avery paper number you’ve got is newer than Publisher’s built-in templates, you can search online for a Publisher template that works. Please contact our Customer Care Center at (800) GO-AVERY for more help, or call Microsoft® for further assistance at (800) 642-7676.Check a template description to see whether it’s designed to work with Avery paper and card stock and if so, with which stock numbers. This will generate the other sheets of labels from the merged data. If you have multiple sheets of labels, select Edit Individual Labels then make sure All is selected and click OK.If it looks right, click Finish & Merge to apply this to all the labels.Options for changing the template colors, fonts, text, and graphics are available. Click a template and check the description to see if the template is designed for your Avery number (e.g. Click Preview Results to see the layout of the first label On the Start page, click Built-In, and choose a template category.Click Update Labels to make format apply to all of the labels.Click Address Block or Insert Merge Field to arrange your data how you want.Browse your files to find your Excel spreadsheet and click Open.Within the Envelopes and Labels pop-up window, click the Labels tab. Click the Labels option within the Mailings tab. To find an Avery Template built into Microsoft® Word: 1. Click Select Recipients and Use Existing List You’ll find Avery Templates on avery.ca and built right into the Microsoft® Word program.Next select your Avery product number and click OK. Click Start Mail Merge, then Labels, then select Avery US Letter in the drop-down menu next to Label Vendors. Mail Merging without using the Step by Step WizardYou can also click on the Mailings tab at the top of the screen. This should create the fully merged document. If everything looks correct then you can click on Next: Complete the Merge.Ĭlick Edit Individual Labels to open the Merge to New Document window.
![avery 5160 label template microsoft word download avery 5160 label template microsoft word download](https://soulcompas.com/wp-content/uploads/2020/09/free-avery-5160-address-label-template.jpg)
If there are any other spaces, line breaks, or characters you need to add you can click on Previous: Arrange Your Labels to go back to the previous step and make adjustments. Then click Update All Labels to apply these changes to the entire sheet. In the first label, you can click between each field to add spaces, line breaks and commas. For example, click on First Name and then click Insert, then click on Last Name and then Insert, and so on. Choose which of your columns to merge and in what order by clicking on each field and then clicking Insert one at a time. Then click Next: Arrange your labels.Ĭlick More items and the Insert Merge Field window will open. Make sure the data is correct and click OK. Once you find and open your Excel file, a window will ask you to select a table.
![avery 5160 label template microsoft word download avery 5160 label template microsoft word download](https://custom-images.strikinglycdn.com/res/hrscywv4p/image/upload/c_limit,fl_lossy,h_9000,w_1200,f_auto,q_1/12654028/jqXAHOJ66fPvKxVHbpmNmoi7NkK05Hi.png)
Then click on Next: Select Recipients.Ĭhoose Use an existing list and Browse. Then scroll to your product number, click on your product number and click OK. In the Label Options window, make sure that the Printer Information is set to Page Printers, Tray is set to Default Tray, and Label Vendor is set to Avery US Letter. Click Start Mail Merge, then Step by Step Mail Merge Wizard.Ĭlick Labels and then click Next: Starting document. Mail Merge with the Step by Step Wizard in Microsoft WordĬlick the Mailings tab at the top of the screen. First, be sure your Excel spreadsheet has one column for each item you want, such as Name, Address, City, State and Zip Code and that this is in Sheet 1 of the spreadsheet file.