Step-3: Creating a Connection of the Dataset with the Labels

If you want to explore the details of your selected label then click on the Details option and then you will see a Preview from where you can change the Margin, Pitch, or Page size. ➤ Choose Avery A4/A5 or your preferred one from the list of the Label vendors and then select the corresponding Product number L7160. ➤ Select the Page printers option and Default tray (Virtual Bin) option in the Tray box. ➤ Then go to Mailings Tab > Start Mail Merge Dropdown > Labels Option.Īfterward, the Label Options dialog box will appear. For this purpose, we have to open a blank Word document at first. In this step, we will select our desired labels in which we will put the information of the employees. Step-2: Selection of Labels in Microsoft Word to Print Address Labels in Excel Here, Excel+Word is the sheet name and $B$4:$G$13 is the data range. ➤ After clicking the Refers to box, select the data range and then you will see the following formula in this box and finally press OK. ➤ Write down Employee_List (or whatever you want) in the Name box and select Workbook as Scope. ➤ Go to Formulas Tab > Defined Names Dropdown > Defined Names Option. Now, we have to set a name for this table. Suppose we want to create the address labels for the employees of the XYZ Company and so, firstly we have created a dataset containing the Name, Phone No., Street Address, City, State, and ZIP code of the employees. Step-1: Creating a Dataset and Defining Name of This Range to Print Address Labels in Excel In this method, we will need Microsoft Excel and Microsoft Word to print out the address labels. Method-1: Using the Combination of Excel and Word to Print Address Labels in Excel We have used Microsoft Excel 365 version here, you can use any other versions according to your convenience. Here, we will demonstrate 2 ways for printing address labels easily, one of them involves the use of Microsoft Excel and Microsoft Word and by this method, you can use as many columns as you need, and the other way needs a VBA code but there is a limitation that you can use only one column here.

How to print address labels in pages