How to prepare the mailing list template
Use our mailing list template to make sure your data is formatted correctly.
Download the template from the Mailing list Template tab. The file is named Vista_MailingListTemplate.xlsx, but you can rename it.
Make sure the column headings match the template exactly, or the list won't upload correctly.
If you're using an existing list, copy the headings from the template into your file and align your data to match the columns.
How to populate the mailing list
All fields must contain text, except for Recipient and Company. You can fill out both, but providing one is enough to process the delivery.
Each field is limited to 40 characters.
Address formatting
Addresses must be broken into separate cells as shown on the template. You'll need to provide the following information for each entry:
Recipient name or company
Address, including street number, name and apartment or unit numbers
City
State
ZIP code
ZIP code formatting
ZIP codes that start with zero may not display the first digit in Excel. This won’t affect your upload. The ZIP code will still work on VistaPrint.
If you want the leading zero to appear in your file, update the cell format in Excel:
Select the cell and select Format Cell
Open the Number tab and select Special from the category list
Choose ZIP code or ZIP code + 4 from the type field
Select Ok
