

Browse to your mailing list file, select it, and press “Open”.Press “Mailings > Select Recipients > Use an Existing List…”.Select your label options and press “OK”.

The mail merge feature will allow you to easily create labels and import data to them from a spreadsheet application. Open the “Mailings” tab of the Word ribbon and select “Start Mail Merge > Labels…”. Once everything has been prepared with the correct column headers, you can save your work and continue to the next step to create labels from Excel. If you’re using your labels for a mailing list, you may want to include heading labels like first name, last name, and title. This will help you to match your fields to the correct columns later on.įor example, in ours we’ll be using the fields property name, operator name, address, city, state, zip code, and country. The important thing to remember is that you must create a column header noting the information that will go in each heading. If you don’t have one, you can create one now. Before you can create labels from Excel, you’ll need your existing mailing list in the application.
