List Requirements

Please note: Any lists sent in formats other than those specified below may be subject to additional processing time and/or programming charges or the file may not be usable.

ALL PC DATA MUST BE SAVED IN AN IBM COMPATIBLE FORMAT. Records must be comma-delimited, dbase or fixed field ASCII with a carriage return line (CR/LF) separating records. Files with specific internal formatting such as Microsoft Excel files will be converted to one of the above formats and will incur the appropriate programming charges.

COMMA DELIMITED IS OUR PREFERENCE.

Please send all files via this web site. Files sent in any other way will incur additional charges.

WORD PROCESSING FILE FORMATS ARE NOT ACCEPTED.

RECORD FORMATS

Each record on your list file should contain a separate and consistent field for each address component. For example, the personal name should always appear in the same field, separate from other fields. The company name should always appear in the same field, separate from other fields, etc. The city, state, ZIP code, and country name should all be in separate fields. If an address does not contain one of the components for which you have established a separate field, then that field should be left blank for that record. State names should be abbreviated in the standard two character, all caps abbreviation, as should Canadian provinces. Country names should NOT be abbreviated.

Data in fields that are longer than the maximums will be truncated. The field maximums are as follows:

• City 16 characters
• State 2 characters
• Zip Code 10 characters
• Line 2 of the label (usually the keyline) 35 characters
• All other fields 40 characters

Example of a Good File Format

Example of a Bad File Format – data floats between the columns