how to print address labels from excel 2010

How to Open Word Document and Save As PDF or Docx with VBA Excel.Copy and Paste from Excel to Word Without Cells (2 Quick Ways).How to Copy Only Text from Excel to Word (3 Quick Methods).Read More: How to Convert Excel to Word Labels (With Easy Steps) Here, all the labels are now linked to the Excel worksheet. As a result, you will see > visible in all the labels except the first one.Choose the excel sheet and put a checkmark on the ‘ First row of data contains column headers’ option. Then Word will show the worksheet present in the selected Excel file.Go to the file path where you have the excel file and click Open.As a consequence, the Select Data Source dialog will appear.Now, to connect Excel data with Word, go to Mailings tab, expand Select Recipients drop-down and press Use an Existing List option.Step 3: Link Excel Data to Labels of MS Word Read More: How to Insert Excel Table into Word (8 Easy Ways) If you do not find the outline, go to Table Design > Borders > View Gridlines. Consequently, you will see the label outlined in Word.As a result, the Label Options dialog appears, set the Label vendors and Product number as per your requirement.

From Start Mail Merge drop-down menu, click on the Labels option.

In this step, first, open a blank Word file and go to the Mailings tab.

If I list the above data in excel, the file will look like the below screenshot.

For example, I want to include First Name, Last Name, Street Address, City, State, and Postal Code in the mailing labels.

First, list the data that you want to include in the mailing labels in an Excel sheet.Step by Step Guideline to Convert Excel to Word Labels Step 1: Prepare Excel File Containing Labels Data

How to print address labels from excel 2010