Variable Data Template and Info

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 ...
    • 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 ...