![]() Step 4:Ĭlick inside any of the 30 labels and type an address. Each of the 30 labels on an Avery 5160 sheet is represented as an empty box on the screen. Step 3:ĭouble-click the file you just downloaded. Save the resulting file-"U-0087-01_P.doc"-to the desktop. Step 2:Įnter your name, email address, and country. Before downloading templates, Avery needs that specific information to be supplied. To get the template, click the blue "Download Template" button. Use the link in the "Resources" section below to get to the Avery 5160 Word template download page. ![]() How to create and print Avery address labels in Microsoft Word Step 1: Using Microsoft Word, create and print Avery 5160 labels using a template. The design is separated into 30 parts so you can preview how the finished mailing labels will appear as you write. A template must be used to print on a sheet of Avery 5160 labels using software like Microsoft Word. The Avery 5160 is a self-adhesive mailing label that comes in sheets of 30 labels. Steps Create Blank Avery 5160 Labels In Word With these rectangular Avery mailing labels and our free 5160 templates, you can stay on top of all your mailing, shipping, and organizing tasks. Using the free address label templates and designs at /templates, you can make customized address labels in no time. These address labels are optimized for laser printers, so you can print sharp text and strong pictures without worrying about smudges. ![]() The postal address labels are simple to peel and attach thanks to the Easy Peel function.īend the label sheet to reveal the pop-up edge, peel off your label, and fold it back flat. Each white label is made with Ultrahold permanent adhesive that sticks to envelopes, cardboard, paper, glass, and metal. Only Avery address labels include our Sure Feed feature, which ensures a more consistent feed through your printer while avoiding jams and misalignments. These mailing labels are great for identifying and organizing personal things in your classroom, garage, house, or business, as well as mass mailing and shipping operations. Please contact our Customer Care Center at (800) GO-AVERY for more help, or call Microsoft® for further assistance at (800) 642-7676.Avery 5160 Easy Peel White Address Labels are ideal for quickly and simply generating professional labels. 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.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.Click Select Recipients and Use Existing List.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. 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. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |