Variable Data Template and Info
Click here for our address list template
To print variable date we'll need these things.
- A normal print ready file with all the text and designs you'd like printed except the variable data
- A file that shows where you want the variable data placed.
- An excel file with each of the different names/information on a separate line. Click here for our address list template
- The font file you'll be using for the variable data. Free fonts are not recommended as they can cause print issues.
Notes about our template
- This template is for mailing but you can easily delete or adjust a column to fit your needs.
- We only use CSV files for addressing since csv files removes erroneous formatting. Check your CSV file before sending it to us as extra returns or spreadsheets will not show up correctly.
- We have extra fields since you can use this template to upload a large address list for UPS/ Fedex/ USPS package shipping as well.
- If you'd like us to use a specific font, please send it along with your list.
Recommendations
- If you want to see a postcard/envelope shipped to your address, put your address in your address list.
- If you're using a file you have already, convert it to CSV before sending it to us so you can make sure your addresses will load properly. XLS files incorrectly formatted will cause delays. Nonstop Printing does not fix database.
- If you'd like us to use a specific font, please send it along with your list.
- Make sure you have room on your mailing piece for an address. Click for usps spacing requirements.
Explaining the columns in our template
- Name / Company - Required. Use the name if no company is listed.
- Attention - Optional. Typically used if Company column is used.
- Phone - Optional
- Address - Required. Place street address here.
- Address 2 - Optional. This can be used for suite number etc.
- City - Required
- State - Required
- Zip Code - Required
- R - Optional. This is used to determine if the address is a residential address vs a commercial address. If the address listed is a residential address, place a capital "Y" in the column. This helps determine a more accurate cost for shipping packages as it costs more to ship to a residential address.
- Email - Optional. Used for shipping fedex packages.
Related Articles
Address List / Farm List / Spreadsheet Template and Information
Click here for our address list template Notes about our template We only use CSV files for addressing since csv files removes erroneous formatting. Check your CSV file before sending it to us as extra returns or spreadsheets will not show up ...
Guide to USPS Processing Acknowledgement Form (PAF)
What is a PAF? The PAF (Processing Acknowledgement Form) is required by USPS to verify the ower of mailing address lists. This is the USPS way to track where mail spam is coming from if needed. What do I need to do to submit this? Nonstop Printing ...
Mailing Postcard Challenges
Mail-piece smudging and scratching The smudge you're seeing is from the mail sorting machines. Here's a picture of ours as well (we send one to ourselves). If you look at any mail piece, you'll notice they all have a smudge around the same area on ...
Notes about our Perfect Binding Style Book Template
Here are some notes about the settings we put in and the reference layer we have on our templates: Reference Layer - Shows how artwork will be affected by the spine of the book. Imagine looking at a softcover book when you open it up and look at the ...
8.5x11 Roll Fold (also known as U Fold) Template
Before you use this template Confirm that the product is for a roll fold, not an accordion fold (also known as a Z fold for tiflods) Template Summary Our template is 11x8.5 open and 3.7285 in x 8.5 closed. It consists of 3 panels on each side. Layed ...