How to Print Avery 8160 Labels from Excel (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

Looking for ways to know how to print Avery 8160 labels from Excel? Then, this is the right place for you. Sometimes, we have to print datasets using Avery or other labels imported from Excel files. Here, you will find 2 detailed steps to print Avery 8160 labels from Excel.


How to Print Avery 8160 Labels from Excel: 2 Steps

We can easily print Avery 8160 labels from Excel with the help of Microsoft Word.  Here, you will find 2 detailed steps to print Avery 8160 labels.


Step-01: Creating Avery 8160 Labels from Excel by Using Microsoft Word

In the beginning, we will create a dataset in Excel and then import the dataset by creating Avery 8160 Labels in Microsoft Word.

Go through the steps given below to do it on your own.

  • First, create a dataset containing the information you want to add in your dataset. Here, we will create a dataset containing the Name, City, State and Zip of some citizens.

Creating Avery 8160 Labels from Excel by Using Microsoft Word

  • Then, click on the File tab.

  • After that, click on Save a Copy option to Save the Excel file.
  • Next, select any location for the file. Here, we will click on This PC.

Creating Avery 8160 Labels from Excel by Using Microsoft Word

  • Now, the Save As box will open.
  • Afterward, select your desired location.
  • Then, type a name of your choice in the File name box. Here, we will type How to Print Avery 8160 Labels from Excel.
  • Next, click on the Save button.

  • After that, open a Microsoft Word file.
  • Then, click on the Blank document.

Creating Avery 8160 Labels from Excel by Using Microsoft Word

  • Next, go to the Mailings tab >> click on Start Mail Merge >> select Labels.

  • Now, the Label Options box will appear.
  • Then, select Avery US Letter as Label vendors.
  • Next, select 8160 Address Labels as Product number.
  • After that, press OK.

Creating Avery 8160 Labels from Excel by Using Microsoft Word

  • Again, from the Mailings tab >> click on Select Recipients >> select Use an Existing List.

Creating Avery 8160 Labels from Excel by Using Microsoft Word

  • Now, the Select Data Source box will open.
  • Then, select the file you want to import. Here, we will select the Excel file named as How to Print Avery 8160 Labels from Excel.
  • After that, press OK.

  • Now, the Select Table box will appear.
  • Then, you can see that your desired table has been selected.
  • Next, turn on the First row of data contains column headers option.
  • After that, click on OK.

Creating Avery 8160 Labels from Excel by Using Microsoft Word

  • Now, you will see that records have been added from the Excel file.

  • Next, go to the Mailings tab to verify if the dataset has been imported as desired.
  • Then, click on the Edit Recipient List feature.

Creating Avery 8160 Labels from Excel by Using Microsoft Word

  • Now, the Mail Merge Recipient box will open.
  • After that, check if the recipients are imported as desired.
  • Then, click on OK.

  • Afterward, go to the Mailings tab >> click on Insert Merge Field.

Creating Avery 8160 Labels from Excel by Using Microsoft Word

  • Now, the Insert Merge Field box will appear.
  • Next, select Name from Fields.
  • After that, click on Insert.

  • Then, click on Close.

Creating Avery 8160 Labels from Excel by Using Microsoft Word

  • Now, you can see that the Name field has been inserted.
  • Then, press SHIFT+ENTER.

  • Again, go to the Mailings tab >> click on Insert Merge Field.

Creating Avery 8160 Labels from Excel by Using Microsoft Word

  • Now, the Insert Merge Field box will appear.
  • Next, select City from Fields.
  • After that, click on Insert.

  • Then, click on Close.

Creating Avery 8160 Labels from Excel by Using Microsoft Word

  • Now, you can see that the City field has been inserted.

  • Similarly, insert the State and Zip fields going through the same steps given above.

Creating Avery 8160 Labels from Excel by Using Microsoft Word

  • After that, from the Mailings tab >> click on Update Labels.

Creating Avery 8160 Labels from Excel by Using Microsoft Word

  • Now, you will see that all the labels have been updated.

  • Again, go to the Mailings tab >> click on Preview Results >> select Preview Results.

Creating Avery 8160 Labels from Excel by Using Microsoft Word

  • Finally, Avery 8160 labels are created using Microsoft Word.

Read More: How to Print Avery 5160 Labels from Excel


Step-02: Printing Avery 8160 Labels

Now, we will show you how to print Avery 8160 Labels from Excel. Follow the steps given below to do it on your own.

  • First, click on the File tab in the Microsoft Word file.

Printing Avery 8160 Labels from Excel

  • Then, click on Save As option to save the Word file.
  • Next, select any location for the file. Here, we will click on This PC.

  • Now, the Save As box will open.
  • Afterward, select your desired location.
  • Then, type a name of your choice in the File name box. Here, we will type How to Print Avery 8160 Labels from Excel.
  • Next, click on the Save button.

Printing Avery 8160 Labels from Excel

  • Then, go to the Mailings tab >> click on Finish & Merge >> select Print Documents.

  • Now, the Merge to Printer box will open.
  • Next, turn on All as Print records.
  • After that, click on OK.

Printing Avery 8160 Labels from Excel

  • Then, the Print box will appear.
  • Next, select Microsoft Print to PDF in the Name box.
  • After that, click on OK.

  • Now, the Save Print Output As box will appear.
  • Then, type a name of your choice in the File name box. Here, we will type How to Print Avery 8160 Labels from Excel.
  • After that, click on Save.

  • Finally, you will be able to print Avery 8160 labels from Excel which will look like the image given below.

Printing Avery 8160 Labels from Excel

Read More: How to Print Labels in Excel Without Word


Download Workbook


Conclusion

So, in this article, you will find detailed steps to print Avery 8160 labels from Excel. Use any of these ways to accomplish the result in this regard. Hope you find this article helpful and informative. Feel free to comment if something seems difficult to understand. Let us know any other approaches which we might have missed here. And, visit ExcelDemy for many more articles like this. Thank you!


Related Articles

<< Go Back To Print Labels in Excel | Mailing Labels in Excel | Mail Merge Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Arin Islam
Arin Islam

Anowara Islam Arin, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Arin exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Besides, she is also interested in Advanced Excel,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo