You can also use our free Avery Design & Print Onlineto create and print your project. After you shift the template, do a test print on plain paper and line that up with your label sheet until you see that it is properly aligned.You can click and drag your mouse to manually adjust the margins, shifting the template up or down (with the ruler on the left) or shifting it right or left (with the ruler at the top) Hover your mouse between the white and gray part of the ruler until you see a two-headed arrow appear.Once this is checked, you will see a Ruler appear at the top and left side of the document.
![download avery word template 5160 download avery word template 5160](https://www.williamson-ga.us/wp-content/uploads/2018/10/free-avery-templates-8160-labels-avery-8160-template-tryprodermagenix-org-of-free-avery-templates-8160-labels.jpg)
![download avery word template 5160 download avery word template 5160](https://i.pinimg.com/originals/96/4c/08/964c08efa282a7dfdb4bc888a8cecb88.jpg)
This should create the fully merged document. Go to Design & Print Online, click Start Designing and enter your Avery product number if you want to print your project yourself, or choose WePrint near the top left of the screen to have Avery print for you. Mail Merge with the Step by Step Wizard in Microsoft Word. 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. 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.
![download avery word template 5160 download avery word template 5160](https://www.heritagechristiancollege.com/wp-content/uploads/2019/05/online-business-card-template-free-download-of-card-visit-template-of-online-business-card-template-free-download.jpg)
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. Then click on Next: Select Recipients.Ĭhoose Use an existing list and Browse. Get free pre-designed templates or start designing today using Avery Design & Print Online. Download free blank mailing templates for Avery 5160 Address Labels to use in Microsoft Office, Adobe Suite and other popular programs. Then scroll to your product number, click on your product number and click OK. Custom-printed Avery labels are available in custom sizes and shapes and ship in as few as three business days. 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.