Please contact our Customer Care Center at (800) GO-AVERY for more help, or call Microsoft® for further assistance at (800) 642-7676. 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.Click Preview Results to see the layout of the first label.
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. Follow these steps: Templates built into Word dont have these problems, so copying and pasting into a built-in template is one option, as long as the label shapes dont get copied over. Then click on Next: Select Recipients.Ĭhoose Use an existing list and Browse. If the gridlines are printing, or if they look extremely misaligned, you can change the file type to a. 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.
Just remember to Pint off to scale.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. That way if something is wrong you can troubleshoot without wasting any label sheets. Print off a few copies of the template on regular paper before printing on the label sheets. Just hide the template layer before printing so that the label lines do not print.Īvery® Compatible Sizes: Click here to see our compatibility chart. Create a second layer and input your artwork. Open the file in your program and lock that as a layer. Right-click and save the PDF file to your computer for use in Illustrator® or any other designing software as a template to layout out your art. If you don't see the label outline, please turn on your Label Gridlines and they will show up. Right-click on the MicroSoft Word® document and save the template to your computer for opening in Word. You may need to use these if you are using a program that you have to enter the label dimensions yourself. Use the detailed image to view the exact layout of the labels on the sheet, as they have the length and width, top and bottom margins, and spaces between the labels marked. All label templates are free to download. Below is a list of all our label sizes with a detailed drawing (JPG), a downloadable MicroSoft Word® template (DOC), an Adobe Acrobat® scaled (PDF) label template, and template files for use in Adobe PhotoShop® (EPS). If you need help setting up your label template, you are in the right place.