Step-4: Inserting Fields to the Labels to Print Address Labels in Excel Then, we will see the word > in each label box except for the first one. ➤ Select the named range Employee_list as we created in Step-1 and make sure that you have checked the box saying the First row of data contains column headers and finally press OK. ➤ Go to Mailings Tab > Select Recipients Dropdown > Use an Existing List Option.įor selecting the data source, at first, select the Excel file which is Address Labels.xlsm for this article and then click Open.Īfter that, the Select Table wizard will appear. Now, we will proceed with making the connection between the labels of the Word document and the dataset of the Excel document. 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.
QUICK PRINT EXCEL CODE
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.
0 kommentar(er)
