How to Build & Print Your Mailing List by Using Microsoft Excel and MS Word

One simple way for a small business to create a mailing list and print your database is by using Microsoft Excel. Here are some simple steps for building and printing your mailing list in Excel:

Step 1: Open Excel

Step 2: Type the names of your data labels in the first row (e.g. First Name, Last Name, Address 1, Address 2, City, State, and Zipcode):

Step 3: Type or paste in your customer or lead list directly into Excel.

Step 4: Save your mailing list.

Step 5: Open a MS Word document

Step 6:Go to the Mailings Menu > Start Mail Merge >Step by Step Mail Merge Wizard

If you have an older version of MS Excel, you can access a similar wizard with this by selecting:  Tools > Letters and Mailings > Mail Merge

Step 7: Choose how you want to print your mailing list.

You can choose to print letters, envelopes, directory, etc. In this example,  we will print address labels for a direct mail campaign so I’m selecting labels. After making a selection, click on “Next: Starting document” at the bottom.

Step 8: Click on “Label Options”

Step 8: Select the Label Vendor you will be using to print your labels.

Step 9: Click on “Select Recipients”


Step 10:  Select “Browse” to find your mailing list excel spreadsheet.

Step 11: Select “Ok” when you get the “Select Table” window.

Step 12: You will get an option to remove anyone on your mailing list that you don’t want to include — and then press OK.

Step 13: Arrange your labels on the label or document you are working with.

Step 14: Save, Update All Labels, and Print.

Get 10 Don’t Miss Marketing Tips To Help Make 2012 A Success


This blog is written and managed by the Experian Small Business Marketing business unit. We are dedicated to helping small businesses market smarter using targeted mailing lists, email marketing software, market profile reports, and print and mail services.

Subscribe by Email

Enter your email address:

Delivered by FeedBurner

Blog Topics

Join us on FB