How to Print Address Labels from Excel to Word Doc

In this tutorial, we will demonstrate two methods for printing address labels using Microsoft Excel and Microsoft Word. The first method combines the power of both applications, allowing you to use as many columns as needed. The second method uses a VBA code but has a limitation, only allowing you to use one column.

Method 1: Using the Combination of Excel and Word

To start, open your Microsoft Excel spreadsheet containing the dataset for your address labels. In this example, we will create a dataset containing the Name, Phone No., Street Address, City, State, and ZIP code of employees at XYZ Company.

First, select the data range that you want to use for printing the address labels. Click on the 'Refers to' box and select the data range. You will see the following formula in this box, which you should press OK to confirm.

Next, write down a name for your dataset in the Name box and select Workbook as Scope. This will help you identify the dataset later.

To set a name for this table, go to the Formulas tab > Defined Names dropdown > Defined Names option. Here, you can assign a name to the dataset that you created earlier. For example, if you are creating address labels for the employees of XYZ Company, you could name it 'Employee_List.'

Now that we have set up our dataset, let's move on to Microsoft Word. Open your Word document and go to the Mailings tab. Click on the 'Envelopes and Labels' button and select 'Labels.' In the Label Options dialog box, enter the name of your dataset (in this case, 'Employee_List') in the 'Address' field.

Choose the label size you want to use and click OK. Your address labels are now ready to print.

In this method, you can use as many columns as needed, making it a flexible solution for printing address labels in Excel.

Printing address labels from Excel to Word doc is a straightforward process that can be accomplished using the combination of both applications or by using VBA code. By following these steps, you can easily create and print address labels with your dataset information.

How to print address labels from excel to word doc