How to Print Avery 5160 Labels from Excel (with Detailed Steps)

Get FREE Advanced Excel Exercises with Solutions!

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.


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.

What Are Avery 5160 Labels?


How to Print Avery 5160 Labels from Excel: Step-by-Step Procedures

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.

Prepare Dataset

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.

How to Print Avery 5160 Labels from Excel

  • 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.

How to Print Avery 5160 Labels from Excel

In the next step, we will illustrate how to insert the mail merge field to create Avery 5160 labels.

Read More: How to Print Avery 8160 Labels from Excel


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.

Insert Mail Merge Fields

  • Next, the Select Data Source window will appear.
  • In the File name box, insert the Excel file containing the dataset.
  • Next, click on Open.

How to Print Avery 5160 Labels from Excel

  • 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.

How to Print Avery 5160 Labels from Excel

  • 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.

How to Print Avery 5160 Labels from Excel

  • 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.

How to Print Avery 5160 Labels from Excel

  • 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.

How to Print Avery 5160 Labels from Excel

How to Print Avery 5160 Labels from Excel

  • 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.

How to Print Avery 5160 Labels from Excel

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


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.

Print Avery 5160 Labels

  • Therefore, Merge to New Document will appear.
  • Next, select the All option in Merge records.
  • Then, click on OK.

How to Print Avery 5160 Labels from Excel

  • 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.

How to Print Avery 5160 Labels from Excel

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.


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.


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 for various Excel-related problems and solutions. Keep learning new methods and keep growing!


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.
Saquib Ahmad Shuvo
Saquib Ahmad Shuvo

Saquib Ahmad Bhuiyan, holding a BSc degree in Naval Architecture & Marine Engineering from Bangladesh University of Engineering and Technology, skillfully integrates engineering expertise with a passion for Excel. He provides solutions to complex issues as an Excel & VBA Content Developer for ExcelDemy Forum. He demonstrates an enthusiastic mindset and adeptness in managing critical situations with finesse, showcasing his commitment to excellence. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, Rhinoceros,... Read Full Bio

6 Comments
  1. 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?

    • Reply Avatar photo
      Naimul Hasan Arif Nov 30, 2022 at 2:56 PM

      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.

  2. 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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo