If you have your database in Excel, you can use Microsoft Word to print labels from that database.

Video will be added in the future.

Printing Labels from Excel Spreadsheet

1. Open Microsoft Word
2. Go to Mailings
3. Start Mail Merge
4. Choose Labels
5. Choose the label manufacture in the Label Products dropdown box (i.e. Avery US Letter)
6. Then choose the specific label you’re using in the Product Number box (i.e. 5161 Address Labels) then click ok
7. Next click the Select Recipients button and choose use an existing list
8. Now navigate to your saved Excel spreadsheet (Richards Contacts), select it then choose open
9. You may get a couple pop-up boxes at this point. If it tells you it needs to open the file with the Excel Workbook Text Converter, click yes.
10. Now it’ll likely give you another pop-up asking if you want to open Sheet1 or the entire workbook. Choose Sheet1 and click ok
11. Now click the insert merge field button and choose which field you want to insert, such as Name.
12. Continue adding the fields from your contact list that you want to show up on your mailing label (Address, City, State, Zip Code).
13. Make sure to add the necessary spaces, commas, etc between the different fields like you would a normal address
14. Once you have all your fields added, click the Update Labels button. This will add all the merge fields you choose to all the rest of the labels.
15. You can now click the preview results button to make sure your labels look right.
16. Now click Finish & Merge and choose Edit Individual Documents. This will open your labels in a new window. Now you can print out your labels.