➤ 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.
![how to print address labels from excel you tube video how to print address labels from excel you tube video](http://www.printablelabeltemplates.com/wp-content/uploads/2017/12/label-template-excel-image-14-mergexcel-Ybokry.jpg)
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.
![how to print address labels from excel you tube video how to print address labels from excel you tube video](https://i.pinimg.com/originals/39/80/e4/3980e488547f0bddd46c8cd1443059f6.jpg)
Now, we have to set a name for this table.
HOW TO PRINT ADDRESS LABELS FROM EXCEL YOU TUBE VIDEO 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
![how to print address labels from excel you tube video how to print address labels from excel you tube video](https://www.exceltrainingvideos.com/wp-content/uploads/2014/11/track-changes-without-sharing-workbook-using-excel-vba.jpg)
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.