how do i create avery 8160 labels in word

Following, navigate to Mailings > Start Mail Merge > Labels.

Secondly, open a blank document in Microsoft Word.

Rather, you may use underscore to separate each word. 📄 Note: Make sure there are no blank spaces between the words.

Now, a dialog box appears where we provide a suitable name, in this instance, Company_Name.

Initially, select the B4:F14 cells and go to the Formulas > Define Name.

Here, the columns show the Company Name, Address, City, State, and Zip Code of each of the recipients. Let’s consider the following dataset shown in B4:F14 cells. You can print Avery labels using Excel and Word. So, without further delay, let’s see how we can print labels.ġ. Here, the first method uses Word to print Avery labels while the second method prints label without the help of Word. Microsoft Excel makes printing labels a simple task so explore the process in detail with the appropriate illustration. Let me know how it goes for further assistance.2 Methods to Print Avery Labels from Excel The nice thing about this version of the software, again assuming you have Word, is that the output creates a Word document format (.doc /.

If you do not have access to Word, I believe you could use the program online (at the website) and then print the output on your printer. I just checked the Template you mentioned is part of the program. I do not know if you have tried this or not, it may be worth a look.Īvery has free software that installs into Office Word: 5- In the OPTIONS dialogue box click on the drop down box to the right of LABEL VENDORS and select Avery A4/A5 6- From the PRODUCT NUMBER list select the Avery template and click on OKįor more details, please follow this link. 2- From the toolbar click on the MAILINGS tab 3- Click on CREATE, then the LABELS sub-category 4- In the ENVELOPES and LABELS box click on OPTIONS. To choose the correct template for Microsoft Word please carry out the following: 1- Click on the Office Button then NEW / BLANK DOCUMENTS then CREATE. In this scenario, I would suggest you try to use Microsoft word. Don't worry I'll try my best to help you with this, I understand that you are having an issue with printing labels on Avery #8160 on your HP Printer. It is a great place to find the help you need, from other users, HP experts, and other support personnel. For you to have the best experience on the HP forum, you could also visit our HP Forums Guide for the First Time Here? Learn How to Post and More. Hi you for showing your interest in HP Support Forums. Business PCs, Workstations and Point of Sale Systems.Printer Wireless, Networking & Internet.DesignJet, Large Format Printers & Digital Press.Printing Errors or Lights & Stuck Print Jobs.Notebook Hardware and Upgrade Questions.

How do i create avery 8160 labels in word