Create Labels in MS Word from an Excel Spreadsheet

To Create Labels in MS Word from an Excel Spreadsheet, Follow the Steps Below:

I have created a short video which outlines the instructions for merging names and addresses from an Excel spreadsheet into pre-formatted labels in MS Word.
My example uses Avery labels, however, MS Word supports a variety of label types.

Before beginning you will want to have an Excel spreadsheet set up with your contact names and addresses. If you are a PracticeMaster user, look for additional videos in this newsletter on how to copy your contact names and addresses into Excel.

Use the first row of your spreadsheet to enter column headers such as: First Name, Last Name, Company Name, Address, City, State & Zip as shown below. This makes it easier to match the fields for your label format.

How to Create Labels in MS Word from an Excel Spreadsheet

How to Filter the Contacts List for Holiday Cards

How to Copy PracticeMaster Contacts into an Excel Spreadsheet


PS: If your video is fuzzy, try changing your settings to HD by clicking on Settings and then Quality.