How should I format my mail list?

1 min. readlast update: 04.05.2024

Please use these Columns in your CSV file. The column for Line Address 2 is optional. Please delete all unused data.*. (If you are mailing video players or surprise sliders the 8 fields below are the maximum allowed).

First Name
Last Name 
Business/Company Name
Address Line 1
Address Line 2
City
State
Zip Code

*Any fields containing more than the maximum number of characters allowed will be truncated on the mailing labels.  Please see limits in the chart below:

 

If you would like to check your data in Excel before submitting to us please follow the below directions:

Company Name Example:

1. Select the Company or Company Name column in the Excel Spreadsheet

2. Go to menu DATA > DATA VALIDATION > enter these parameters… (then click OK)

  1. Go to menu DATA > CIRCLE INVALID DATA

4. Red Circles will now be displayed showing all Company fields that are over 50 characters in length and will be truncated on a mail label.

 5. Retype the data until it either equals 50 characters or less to meet the data validation parameters. Excel will keep warning you if you are over the character limit and you can keep trying until it passes.

 

 

 

 

Was this article helpful?