Database Management for Mailing

Doing it Right, the First Time

There are three things every mailer can do to reduce their postage expenditures on Standard Mail mailings:

1. select the correct software package to maintain your database
2. enter the information into your database in the correct, standardized format
3. design your mail pieces to be compatible with Postal Service automated equipment.

Please refer to the http://www.usps.com/send/preparemailandpackages/preparingmail.htm web site for all addressing standards.

The information here is focused on database management issues. For more information on mail piece design, call Campus Mail Services at 581-6035 to take advantage of available cost savings. Remember, the indicia must be either printed directly on or hand-stamped on each mail piece prior to processing. Mail Services also has the capability to print the indicia on each mail piece if it is automation compatible.

Database Management Software:

Select a software package that was designed specifically for database management. The software should be flexible enough to make changes to the database design for future needs. It should save the file in an industry standard format (i.e., dBase) so that the information can be merged into letters on your word processor for that personalized look. And finally, the database should save the file in ASCII delimited (i.e. comma, tab, etc.) or fixed field length formats.

Most word processing packages can handle simple address set ups, but they were not designed to easily perform all the different kinds of work you will need to do with your address data, such as sorting, duplication checking, etc. Campus Mail Service's barcode machine will print it in ZIP Code order and can merge data disks together.

Data Entry:

The key to successful data processing is consistency in the way the data is entered. The preferred way is to follow the Postal Service's addressing standards.