SPREADSHEET SETUP FOR GUEST ADDRESSING
A correctly formatted spreadsheet is required before you can begin designing your envelopes. See the formatting instructions below for recommendations.
Start with a clean spreadsheet. Do not add tabs, extra spaces, or carriage returns within cells.
- Create the following columns: Name, Address, City, State, Zip and optionally Country.
- Enter your guest information exactly as you would like it to appear on your envelopes.
For names or addresses that you would like to have on a second line, use a semi-colon ( ; ) to denote the line break.
An example of a properly formatted guest addressing spreadsheet. The inner envelope column can be omitted if you are not using our name printing service.
CREATE YOUR FILES
To create your ready-to-print pdf files, think of back and front! Do you need only one side? then one pdf! Two sides? two pdfs!
Just like the front and back, the size of your artwork has to be the size of the front or the back. The front is easy! Use the size of the envelope from your insert (i.e. A7 = 5.25 x 7.25), but the back changes depending on the flap, either square, pointed or euro, make sure you are using the right size (ask us if you have any questions).
Use the templates below for our
commonly printed envelopes to get you started.
A7 C&P Euroflap
AUTO-GENERATE AND FORMAT YOUR ADDRESSES
Using InDesign, the Data Merge function allows you to auto-generate and format your addresses to your liking! It will be easy if you have your spreadsheet set up correctly!
Use this video to find out how to make it work!
* If you’re printing white ink, please have your type be 100% black (K in CMYK).
SEND US THE FILES
At this point, you should have your indesign file with all your addresses, make sure you export your pdf for print (not interactive). And we should be ready to get it printed!