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.

Have Questions?

We provide all the resources you need for your business data and list needs. Contact us today so that you can focus on growing your business.