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.
Download Workbook
2 Steps to Print Avery 8160 Labels from Excel
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 will 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.
- 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.
- 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.
- 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.
- Again, from the Mailings tab >> click on Select Recipients >> select Use an Existing List.
- 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.
- 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.
- 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.
- Now, the Insert Merge Field box will appear.
- Next, select Name from Fields.
- After that, click on Insert.
- Then, click on Close.
- 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.
- Now, the Insert Merge Field box will appear.
- Next, select City from Fields.
- After that, click on Insert.
- Then, click on Close.
- 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.
- After that, from the Mailings tab >> click on Update Labels.
- Now, you will see that all the labels have been updated.
- Again, go to the Mailings tab >> click on Preview Results >> select Preview Results.
- Finally, Avery 8160 labels are created using Microsoft Word.
Read More: How to Print Labels from Excel in Word (with Easy Steps)
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.
- 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.
- 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.
- 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.
Read More: How to Print Avery Labels from Excel (2 Simple Methods)
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
- How to Print Labels in Excel Without Word (with Easy Steps)
- How to Print Avery 5160 Labels from Excel (with Detailed Steps)
- How to Print Barcode Labels in Excel (with 4 Easy Steps)
- How to Print Labels in Excel (With Easy Steps)
- How to Print Address Labels in Excel (2 Quick Ways)