How to Print Labels from Excel in Word (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

If you want to print labels then Microsoft Excel and Word can be the best solution. You can create a list of label data in Microsoft Excel After that get that data from Excel into Word. Then you can print those labels easily. This article will mainly focus on how to print labels from Excel into Word effectively. I hope you find this article informative and gain more knowledge about print labels.


How to Print Labels from Excel in Word: Step-by-Step Procedures

To print labels from Excel in Word, we have found step-by-step procedures through which we can easily do this work. In this article, we will prepare data labels in Excel. Then, in MS Word, we select the labels and insert the labels. Finally, we can print those data labels.


Step 1: Prepare Dataset

Before printing labels from Excel in Word, you need to prepare a dataset in Excel. In our dataset, we include name, address, and contact no.

  • First, we create some column headings such as Name, Address, and Contact.
  • In the Name column, we put some names.
  • Then, in the Address column, we put the address of those people.
  • Finally, in the Contact column, we put the mobile no. of those people.

How to Print Labels from Excel in Word

  • Next, go to the File tab in the ribbon.
  • Then, select Save As option.
  • After that, click on Browse.

  • Then, set the name in the File name Here, we set Contact Details as the file name.
  • Finally, click on Save.


Step 2: Select Labels in MS Word

In our second step, we need to open MS word. From there, we have to select labels using the Mailings tab on the ribbon. To understand it properly, go through the following steps.

  • First, you have to open an MS Word documents file.
  • Then, select the Mailings tab in the ribbon.
  • After that, from the Start Mail Merge dialog box, select Start Mail Merge drop-down option.

How to Print Labels from Excel in Word

  • Then, from the Start Mail Merge drop-down option, select Labels.

How to Print Labels from Excel in Word

  • The Label Options dialog box will appear.
  • Then, select Avery US Letter from the Label vendors section.
  • After that, from the Product number section, the 5160 Address Labels option.
  • Finally, click on OK.

Read More: How to Print Avery Labels from Excel


Step 3: Insert Excel Data into MS Word

In this step, we will try to bring the created Excel data into MS Word. We can use the Select Recipients option from the Mailings tab on the ribbon. To have a clear idea of this step, go through the following steps carefully.

  • First, go to the Mailings tab in the ribbon.
  • Then, from the Start Mail Merge group, select the Select Recipients drop-down option.

  • After that, from the Select Recipients drop-down option, select the Use an Existing List option.

How to Print Labels from Excel in Word

  • Then, the Select Data Source dialog box will appear.
  • From there, select the Contact Details Excel file.
  • Finally, click on OK.

  • Then, the Select Table dialog box will occur.
  • Check on the First row of data contains column headers.
  • Then, click on OK.

As a result, we will get the following format where you need to put your preference data.


Step 4: Insert Merge Field

In this step, we are going to insert the Name, Address, and Contact column in the labels. We need to insert those items from the Insert Merge Field option. You need to go through the steps properly to have a clear view.

  • First, go to the Mailings tab in the ribbon.
  • Then, from Write & Insert Fields tab, select Insert Merge Field drop-down option.

How to Print Labels from Excel in Word

  • Then, from the drop-down menu, select the Name option.

  • It will give us the following result. See the screenshot.
  • Here, we also make the Name bold.

How to Print Labels from Excel in Word

  • Before doing anything, press Enter to go to a new line.
  • Then, we do the same thing again.
  • From the Insert Merge Field drop-down option, select Address.

How to Print Labels from Excel in Word

  • It will put the address just below the name. See the screenshot.

  • Then, again press Enter to go to a new line.
  • After that, from the Insert Merge Field drop-down option, select Contact.

How to Print Labels from Excel in Word

  • It will put the contact just below the address. See screenshot.

How to Print Labels from Excel in Word

  • To complete other label fields, go to the Mailings tab in the ribbon.
  • Then, from the Write & Insert Fields group, select Update Labels.

How to Print Labels from Excel in Word

  • As a result, you will get the following address labels. See the screenshot.

  • Now, our format is ready. We need to put our data into the address labels.
  • Before going to the final results, we need to show the preview.
  • First, go to the Mailings tab in the ribbon.
  • Then, from the Preview Results group, select the Preview Results option.

How to Print Labels from Excel in Word

  • It will give us the following preview after applying our data. See the screenshot.

How to Print Labels from Excel in Word

Read More: How to Print Address Labels in Excel


Step 5: Print Labels in MS Word

After creating the labels, we are going to print labels. But before that, we need to mail and merge the labels. To have a complete idea, go through the steps carefully.

  • First, go to the Mailings tab in the ribbon.
  • Then, from the Finish group, select Finish & Merge drop-down option.

  • From the Finish & Merge drop-down option, select Edit Individual Documents.

How to Print Labels from Excel in Word

  • Then, the Merge to New Document dialog box will appear.
  • From the Merge records section, select All.
  • Then, click on OK.

  • As a result, we will get the required labels, See the screenshot.

How to Print Labels from Excel in Word

  • Then, go to the File tab in the ribbon.
  • From there, Select Print.
  • Then, select any printer from your preference.
  • After that, click on Print.

How to Print Labels from Excel in Word

Read More: How to Print Avery 5160 Labels from Excel


Things to Remember

  • To print labels in Word, you need to prepare a dataset in Excel first.
  • Instead of Avery US Letter from the Label vendors section, you may use the other labels.

Download Practice Workbook


Conclusion

We have shown step-by-step procedures to print labels from Excel in Word. In this article, we try to prepare a dataset in Excel, and then from MS Word, we insert these data labels. After that, we print labels. All of these steps are fairly easy to use in your day-to-day purposes. I hope we cover all possible areas of printing labels from Excel in Word. If you have further questions, feel free to ask in the comment box. Don’t forget to visit our Exceldemy page.


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.
Durjoy Paul
Durjoy Paul

Durjoy Kumar, with a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, is a dedicated contributor to the ExcelDemy project. His substantial contributions include crafting numerous articles and demonstrating expertise in Excel and VBA. Durjoy adeptly automates Excel challenges using VBA macros, offering valuable solutions for user interface challenges. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, SPSS, C, C++, C#, JavaScript, Python Web Scraping, Data Entry... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo