Ever been in charge of a large-scale mailing project? You have to manage different mailing lists, sometimes with duplicate names, and you have just a couple of days to get that stack in the mail. Large-scale mailings can seem daunting, but don’t despair. With Avery Wizard Software for Microsoft® Office you can go from mailing list to labels in just three easy steps—and get mailings out in no time flat.
1. Make a list. Assemble all names and addresses into one consolidated list using a program such as Microsoft® Excel®, Outlook®, Access®, or Word. If you don't have a spreadsheet with all of your names and addresses, you can start with our pre-formatted files for Microsoft® Excel or other database programs. The simple investment you put into compiling your list now will be worth the time and effort you save doing your mailings in the future.
2. Clean up the list. Check the list over for redundant names, check ZIP Codes to make sure they are accurate, and make sure your addressing format is consistent. Having a clean, accurate list will help you avoid wasting postage.
3. Prepare mailing labels. Avery Wizard for Microsoft® Office can guide you step by step to create your mailing labels. You’ll be able to import your data from your database program and perform a mail merge in just minutes. You’ve now created mailing labels based on the information from your mailing list.
Now that you’ve gotten the knack for creating mailing labels, check out these mailing tips to help you manage your large-scale mailing without a hitch:
- There are many good mailing software programs out there, but you may already have a tool on your desktop that can help you create a mailing list. Microsoft® Excel®, Outlook®, Access®, and Word are all worth considering.
- The U.S. Postal Service® recommends using the two-letter state abbreviations instead of writing out state names. In addition, there's no need for a comma after the city when you address your mail.
- Why waste postage on undeliverable mail? If you feel your mailing list may be out-of-date, run your list through NCOA (National Change of Address) software. This service is provided by vendors that are certified and licensed by the U.S. Postal Service®. Although there are fees involved, the benefit of having a clean mailing list is well worth it. For more info, visit the U.S. Postal Service Web site.
- To further clean your mailing list after your mailing goes out, consider using Ancillary Service Endorsements. These are specific instructions you give the U.S. Postal Service on how to handle your mail if it is undeliverable. First-Class Mail is forwarded free of charge and, if undeliverable, returned to you for free. This can help make sure more mail reaches its intended destination in the future. Learn more at www.usps.com.
- Make applying your address labels easier by using Avery Easy Peel White Mailing Labels. Just print your labels, bend the label sheet to pop up the label's edge, grab the edge of the label, and peel. And with the Avery Wizard, you can choose to print your labels vertically (in columns) when you mail merge to work with the Easy Peel feature.