Submitting Your Marketing Mailing List

The following mailing list formats are accepted and must include a data layout showing the field names:

• Excel - Must provide column headers
• Access - Your queries must include only the names you want us to mail to
• Comma Delimited
• DBase

The following outlines the list formatting guidelines that are required.
All fields must be limited to a maximum of 40 characters.

Separate Columns
Many direct mail lists are submitted without using separate columns for each category (Company, Name, Address, City, State, Zip etc.) With the software that we use, it is necessary for each category to be separated into its own column, although the First Name and Last Name fields can be combined into one single column. If your mailing list is not submitted in this format, we will not be able to match up the data with the appropriate field and your list will be returned for clarification, which may delay your direct mail printing job.

Column Names
While we understand the need to use distinctive headings and column names, using recognizable column titles on the direct mail list you submit to us will make it easier to match up the necessary fields during the mapping process, ensuring there are no errors. We suggest using the following column titles as shown below in Figure A:

• Company
• First Name *
• Last Name *
• Address #1 (Street Address)
• Address #2 (Apt/Suite/Floor)
• City
• State
• Zip Code

Figure A

Multiple Worksheets
If the spreadsheet you are submitting has multiple worksheets you should make sure that all mailing information appears on one worksheet and that all blank worksheets are removed from the spreadsheet.

Number of Columns
The maximum number of lines that can be printed on each mailing label is six (6). If your mailing list has too many fields to conform to this guideline, the order will be delayed. You should make sure your list does not exceed six (6) lines of text for any label.

Using Figure A from above as an example your label would look like the following:

ABC Company
John Doe
123 Main Street; 2nd Floor
Boston, MA 02210

In this example you would have two more lines available for other information.

Address/Quantity Discrepancies
If your mailing list contains more names than the quantity ordered, the system will automatically start selecting the deliverable addresses from the top of your list to satisfy the quantity ordered. You will then be prompted during the order process to either ship the remainders back via UPS Ground or discard the remaining pieces. If your mailing list contains fewer names than the quantity ordered, the system will simply use all of the deliverable addresses. You will still be prompted during the order process to either ship the remainders back via UPS Ground or discard the remaining pieces.

Foreign Records
48HourPrint.com does mail to countries outside of the United States. If a mailing list has foreign addresses included, they will need to be separated out and sent as a separate mailing list to mailing@48HourPrint.com. The mailing list containing the US addresses would be uploaded on our website along with your graphic file(s). Please note that we can not scrub the foreign address list and they are mailed out exactly as they appear on the list provided.