Sending a file for automated processing.
Automated processing is a requirement for all subscription holders. By meeting the guidelines below, users can submit jobs 24/7/365, excluding our scheduled maintenance.
Field Requirements
File must use our standard field names (identified below in bold) or be properly mapped with a template.
Name Information can be sent in Full Name or Parsed Name format:
- Name – Ms. Jane Smith
Or
- Prefix optional – Ms.
- Fname (first name) – Jane
- Mi (middle initial) – optional
- Lname (last name) – Smith
- Suffix – optional
- Company (firm or company name)
- Address (primary address – no more than 60 characters)
- Address2 (secondary address – no more than 60 characters) – optional
- Address3 (tertiary address – no more than 60 characters) – optional
- City
- State
- ZIP (with or without ZIP + 4)
Additional Fields for Presort
Note: These fields are only required on the input file when services that provide them are not run in the same job. For instance, if a job does not include DSF2 processing, but the presort is set to sort for walk sequence, then the Dsf2wlkseq, Dlvpnt and Crrt fields are required on the input file.
- ZIP (10 or 9 digits) or ZIP (5 digits) and ZIP4 (4 digits)
- Dlvpnt – Delivery point
- Crrt – Carrier route number for USPS Marketing Mail® carrier route and walk sequence mailings
- LOT or LOTno – Line-of-travel number for USPS Marketing Mail carrier route mailings
- LOT_order or LOTord – Line-of-travel ascending or descending for USPS Marketing Mail carrier route mailings
- Dsf2wlkseq – Walk sequence number for USPS Marketing Mail walk sequence mailings
File Requirements
- File must be saved in one of the following formats:
- DBase III
- Comma delimited
- Tab delimited
- Pipe delimited
- Excel – Versions supported: Excel 97 or newer
- Fixed field ASCII (File layout must be consistent for all input files and requires setup prior to processing. Contact us to learn more.)
- File name must contain only letters and/or numbers, no spaces or special characters.
- File name must not exceed 32 characters.
- Record quantity must match the quantity specified or fall within the tolerance level selected.
- Submit only one file (only one Excel worksheet may contain data.) That file may be zipped without a password or unzipped.
Payment Method
A valid payment method must be established prior to submitting the job.