![how to print address labels from excel sheet how to print address labels from excel sheet](https://i.pinimg.com/originals/c2/ea/65/c2ea65273500c5cea23f19871746af87.png)
Once you have selected the excel spreadsheet and you see the name of the excel spreadsheet appear in the “File Name” field, click the grey "Open" button.ġ7. Find the Excel spreadsheet that you saved to your computer and click on it to select.ġ6. The “Select Data Source” popup will appear.ġ5. Click "Use Existing List." in the drop down menu that appears underneath.ġ4. Go back up to the sub-menu and click "Select Recipients"ġ3. In the section named “Product number” select the product number of the labels you are using as well.įor example, the product number of the Avery US Letter labels that we use in our office, is “5160”.ġ2. In the section named “Label vendors” select the name of the vendor that makes your labels.įor example, the labels we use in our office are made by “Avery US Letter”.ġ0. Click on "Labels." in the drop down menu that appears underneath.Ĩ. Click on "Start Mail Merge" in the submenu that appears underneath.ħ. Depending on the version of Microsoft word you have (I have version 2007), you will click on "Mailings" in the menu bar that runs across the top of the document.Ħ. Open a separate blank MS Word document.ĥ. (you can just save it to your desktop).Ĥ.
![how to print address labels from excel sheet how to print address labels from excel sheet](https://images.sampletemplates.com/wp-content/uploads/2016/08/10142758/Examination-Attendance-List-Template.jpg)
Delete any unnecessary columns that you do not want to print on the address label.įor example: I would delete all columns except: Last Name, First Name, Address 1, Address 2, City, State, Zipģ.
#How to print address labels from excel sheet download#
Download your “Patient List” into an Excel file. Should the product be out of stock on or if you want to see if another website offers these labels at a lower price, we suggest going to and searching for the phrase: Avery 5160 White Laser Address Labels.ġ. *The above link is to purchase to purchase the address labels online from. We recommend Avery® 5160 White Laser Address Labels (30 per sheet) in order to follow the instructions outlined below: