How do I upload my mailing list?
One of the most important aspects of any direct mail campaign, is the recipient data. You can add recipient data to your Stannp account, and to your campaigns, in a number of ways.
To send your direct mail campaign you'll need a mailing list. You can upload this as part of a campaign setup journey or from your dashboard, at any time.
Here is a step-by-step guide for uploading your recipient data:
Important points when uploading your data
Single sheet data files
Only single sheet data files can be accepted. CSV is the accepted file type as this only saves as a single sheet document. Stannp.com will convert alternate file types (such as xls or xlsx) to CSV. If your files contains multiple sheets, only sheet one will upload. This means any data or formulas, on others sheets, will not be saved.
Essential address data
Address line 1 and the zip code must be mapped correctly in order to verify against the USPS database. Addresses that do not match will save as unverified and may incur an additional cost.
Read more about Address Verification here.
Retain zip codes starting with '0'
To ensure Zip codes starting with '0' (zero) are accurately retained in your data file, you should untick the 'Remove leading zeros and convert to a number' (fist image below) option in your Excel settings or convert your cell style from 'General' to 'Text' in the 'Home' tab (second image below)


View and manage all of your recipient groups in one place

Click 'View' on your recipient group to view, edit, add to, and manage your recipient data within that group.
Need data?
If you don't have any data yet, you can always buy data from us instead!
Adding data with custom fields
If your data file contains any custom column headings, these will automatically be uploaded with your data file. You can choose to map these or skip them (click the red 'x').
If you have previously added the custom field, this will appear. Example below: Birthday was previously added and has mapped.
If the column name is new, you can map this as a 'New Custom Field' in the drop down. Example below: 'Pet name' is new.

When using custom variable fields we always recommend making the variable first in the column settings rather than generating it here.
Read more about creating custom variables here
The final step is to check through your data settings. Give the mailing list a name to easily find later, and decide what you would like us to do with any duplicated entries that could feature in your other recipient groups. If you want to make sure all of your recipients are uploaded, we recommend selecting the "insert all duplicates as unique records" option.
Once uploaded, it will be displayed in your groups. It will give you a breakdown to the verified and not verified recipients along with any international records in your mailing list.
Select the data when creating a bulk campaign and you're off to go!