Popular Articles

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.