How to Print Address Labels from Excel to Avery Labels

Are you tired of manually writing address labels for your business or personal use? If so, then this step-by-step guide is for you. In this article, we will show you how to print address labels from Excel to Avery labels using Microsoft Word.

To begin with, open MS Excel and create a dataset that includes the information you want to display on your labels. This can include columns such as Name, Address, Contact Number, and any other relevant details. For our example, let's assume we have created three columns: Name, Address, and Contact.

Once you have prepared your data in Excel, it is time to merge this data with Avery labels in MS Word. To do this, follow these steps:

1. Go to the Start Mail Merge group and select the Select Recipients drop-down option.

2. From the Product number section, choose 5160 Address Labels as the label type.

3. Select Avery US Letter from the Label vendors section.

4. The Label Options dialog box will appear. In this box, set the file name to 'Contact Details' and click OK.

Next, open an MS Word document file and select the Mailings tab in the ribbon. From there, you can select labels using the Mailings tab on the ribbon.

5. Create a new label by selecting the Avery 5160 Address Labels option from the Start Mail Merge dialog box.

6. In the Label Options dialog box, set the file name to 'Contact Details' and click OK.

7. Now, go back to your Excel dataset and select all the data columns except the header row. Copy this data and paste it into the MS Word document.

8. Select the entire label area in MS Word and then right-click on it. Choose the 'Insert Table' option from the context menu.

9. In the Insert Table dialog box, set the number of rows to match the number of labels you want to print. Set the column width to match the Avery label size.

10. Finally, click OK to insert the table into your MS Word document.

Now that you have inserted the table, it is time to merge this data with the Avery labels in MS Word. To do this, follow these steps:

1. Go to the Start Mail Merge group and select the Labels option.

2. In the Start Mail Merge dialog box, select the 'Start Mail Merge' drop-down option.

3. The Label Options dialog box will appear. Set the file name to 'Contact Details' and click OK.

4. Now, go back to your MS Word document and select all the label text. Right-click on it and choose the 'Update Labels' option from the context menu.

5. In the Update Labels dialog box, set the update options as desired and click OK.

6. Finally, print the labels using your printer or save them as a PDF file for later use.

With these steps, you should be able to print address labels from Excel to Avery labels easily and efficiently. This will save you time and effort compared to manual writing of labels.

For more information on printing labels in Excel without Word, read our article: 'How to Print Labels in Excel Without Word (with Easy Steps)'(https://www.example.com).

How to print address labels from excel to avery labels