QUICK GUIDE TO PREPARING DATABASES FOR MAILING

Excel is the most common program for sending mailing lists, but this would apply to any list that we will be using for addresses your envelopes or other mail.

Be sure that the only data in the Address field is the mailing address.
Company names, C/O, Building Names, Office complex names, etc. DO NOT belong in the Address field. These should do in a filed called Company.

Be sure to DELETE any columns that we do not need for mailing
ie: Internal customer numbers, donation amounts, etc. These columns cannot just be hidden, they must be DELETED. When we bring your list into our mailing software or variable program it sees EVERY FIELD, whether it’s “hidden” or not. Please send clean lists with ONLY THE DATA we need for mailing
Separate City, State and zip into separate columns. We don’t need the zip plus four, as our software will automatically add it when checking address integrity

Be sure to spell street names correctly
The Address 2 Field should only be used for Apt Numbers, Suite Numbers, etc
When designating an apartment number or street number, us #, STE, or APT. Do use NO. NO. for the post office signifies NORTH and the address will come back undeliverable.