Standard Microsoft office products such as Avery 5160 Labels are very well known. If you are looking for some special tricks to print Avery 5160 labels from Excel, you’ve come to the right place. There is one way to print Avery 5160 labels from Excel. This article will discuss every step of this method to print Avery 5160 labels from Excel. Let’s follow the complete guide to learn all of this.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article. It contains a dataset in the spreadsheet for a clear understanding. Try yourself while you go through the step-by-step process.
Overview of Avery 5160 Labels
Avery 5160 mailing labels are self-adhesive and include 30 labels on each sheet. One can easily create Avery 5160 labels in Microsoft word by using the MS Excel data. In the following picture, we can see the Avery 5160 labels.
Step-by-Step Procedure to Print Avery 5160 Labels from Excel
In the following section, we will use one effective and tricky method to print Avery 5160 labels from Excel. For clear understanding, we are going to demonstrate the whole process step by step. Firstly, we will prepare a proper dataset, then we will create Avery 5160 labels. To create Avery 5160 labels, firstly we have to set up labels in Microsoft Word, then add mail merge field. After creating Avery 5160 labels, we will illustrate how to print these. This section provides extensive details on this method. You should learn and apply these to improve your thinking capability and Excel knowledge. We use the Microsoft Office 365 version here, but you can utilize any other version according to your preference.
Step 1: Prepare Dataset
To create Avery 5160, we have to follow some specified rules. At first, we want to make a dataset. To do this we have to follow the following rules.
- Firstly, enter the Name, Address, and Column in the following dataset. Click here to see a screenshot that illustrates what the fields look like.
- In the Name column, we enter each person’s name.
- Next, in the Address column, we enter each person’s address containing city and state.
- Then, in the Contact column, we enter each person’s contact number.
In the following steps, we will create Avery 5160 labels using the above dataset and then print them.
Step 2: Select Avery 5160 Labels in MS Word
Now, we are going to create Avery 5160 labels. To do this, we have to follow some specific processes. First of all, we have to set up Avery labels in Microsoft Word. Let’s walk through the following steps to set up Avery 5160 labels in MS Word.
- Firstly, you have to open an MS Word document file, then go to the Mailings tab.
- Then, select Start Mail Merge and from the drop-down menu select the Labels option.
- Then, the Label Options window will appear.
- In this window, you have to select your desired option in Page printers or leave this as the Default tray as shown below.
- Next, you have to select the Avery US letter in the Label vendors box.
- Afterward, you have to select 5160 Address Labels in the Product Number option.
- Finally, click on OK.
In the next step, we will illustrate how to insert the mail merge field to create Avery 5160 labels.
Read More: How to Print Labels from Excel in Word (with Easy Steps)
Step 3: Insert Mail Merge Fields
Now, we will demonstrate how to insert the mail merge field to create Avery 5160 labels. In order to accomplish this, we need to follow a few specific steps. Let’s walk through the following steps to insert the mail merge field in MS Word.
- First of all, go to the Mailings tab, and click on Select Recipients.
- Then, from the drop-down menu select the Use an Existing List option.
- Next, the Select Data Source window will appear.
- In the File name box, insert the Excel file containing the dataset.
- Next, click on Open.
- Then, the Select Table window will appear.
- You have to check the Frist row of data contains column headers.
- Next, click on OK.
- Therefore, you will get the following Avery 5160 format data where you have to input your preference data.
- Now, we are going to input the Name, Address, and Contact columns data in the Avery 5160 address labels.
- To do this, go to the Mailings tab, and select Insert Merge Field.
- Then, from the drop-down menu select the Name option.
- Therefore, you will see that the Name field will be inserted.
- Then, press Enter to go to the next row.
- Next, to insert the Address field, go to the Mailings tab, and select Insert Merge Field.
- Then, from the drop-down menu select the Address option.
- Consequently, you will see that the address field will be inserted.
- Then, press Enter to go to the next row.
- Next, to insert the Contact field, go to the Mailings tab, and select Insert Merge Field.
- Then, from the drop-down menu select the Contact option.
- As a consequence, you will get the following address label.
- To complete the other labels fields, you have to go to the Mailings tab and select Update Labels.
- This feature will automatically update other labels.
- Therefore, you will get the following address labels.
- Now, we are going to fill the address labels format with our own data.
- To do this, go to the Mailings tab and select ABC Preview Results.
- As a consequence, you will get the following Avery 5160 labels.
We will be able to generate Avery 5160 labels by following the above steps, and we will demonstrate how to print them in the next step.
Read More: How to Print Labels in Excel Without Word (with Easy Steps)
Step 4: Print Avery 5160 Labels
Now, after creating the Avery 5160 labels, we are going to print these labels. Before printing, we have to mail and merge the labels. Let’s walk through the following steps to print Avery 5160 labels.
- First of all, go to the Mailings tab and select Finish & Merge.
- Then, from the drop-down menu select Edit Individual Documents.
- Therefore, Merge to New Document will appear.
- Next, select the All option in Merge records.
- Then, click on OK.
- As a consequence, you will get the following Avery 5160 labels.
- To print these labels, click on File and select Print.
- Next, select your preferred Printer.
- After customizing, click on Print.
If you want to print these labels from Excel, you have to save the word file Plain Text(.txt) file. Then You have to open an empty Excel file, go to the Data tab and select From Text/CSV and insert the .txt file. Then you have to load the file in Excel and print this file by going to the Print option from the File tab. But the problem is you will not get the Avery 5160 labels in their format, you will get these labels in imperfect format. That’s why we print these Avery 5160 labels from MS Word.
Read More: How to Print Avery 8160 Labels from Excel (with Easy Steps)
Conclusion
That’s the end of today’s session. I strongly believe that from now you may be able to print Avery 5160 labels from Excel. If you have any queries or recommendations, please share them in the comments section below.
Don’t forget to check our website Exceldemy.com for various Excel-related problems and solutions. Keep learning new methods and keep growing!
I got all the way to finish and merge new document. Hit ok then nothing more happened. Just the blue icon spinning for eternity. Any idea?
Hello DAMON,
The process should work perfectly. It would be very helpful for me if you could just send me the file to give it a try.
THANK YOU FOR THE STEP BY STEP, THESE INSTRUCTIONS WERE SO HELPFUL !!
Hello, Leslie!
Hope you are doing well. Thanks for your appreciation. Stay in touch with ExcelDemy.
Regards
ExcelDemy