FORMATTING REQUIREMENTS FOR YOUR DIRECT MAIL LIST
Submitting a direct mail list to Online Prints for your postcard or other direct mail campaign? You'll want to make sure your mailing list meets the following formatting requirements.
Please note that use of your direct mail list is subject to our processing disclaimer: We are not responsible for verifying that your list data is accurate and properly formatted for mailing. While we will standardize address formats, we will not correct list format errors or incomplete addresses.
Direct Mail List Formats
Online Prints will review your mailing list to ensure it meets the basic format requirements of our system. We will work with you if your list needs to be converted from a different format, for example, but please be aware that if your list does not meet our specifications, additional costs and processing delays may be incurred.
Preferred list format: PC based text, tab delimited files (.txt)
Acceptable list formats (PC or MAC): .txt, .ascII, .asc, .csv and .dbf (dbfIII)
These types of files can be produced from common PC and Mac programs such as:
- Excel
- Microsoft Works
- QuickBooks Pro
- Filemaker Pro
- Label Maker Pro
- Outlook
Acceptable Digital Formats
- Tab-delimited
- CSV (comma separated values or comma-delimited)
- ASCII
- DBF III
- MS Excel (if your file contains multiple worksheets, each will be processed as a separate list)
Acceptable list extensions (PC or MAC): .txt, .tab, .csv, .asc, .dbf, .xls
To see the extension of your file, check the 3 letters at the end of the file name (for example, customerlist.txt). Please be aware that even if your list is in an acceptable file format, there may be other issues that render it unusable.
For more information, please call toll-free (800) 880-4571 to talk with an Online Prints representative.
