How can I automate printing from a template?

August 20, 2007 2:55 PM

Say I have a template document in Adobe Illustrator or InDesign, and a spreadsheet with information. I need to put one row of that data into the template, print and/or save it, then put in the next row into the template, etc. Can this be automated?

For example I need to print out several envelopes or name badges from a template with addresses/names organized in an Excel spreadsheet, and wouldn't like to go in and manually change every name by hand. Is there some software or feature that would allow me to do this?

posted by mwang1028 to computers & internet (2 comments total)

The phrase you're looking for is "data merge." These two links should get you started w/ inDesign. I haven't done it myself, so I'm not sure how well it works, but it is possible!
posted by wemayfreeze at 3:01 PM on August 20, 2007

Yep. InDesign's data merge will do it. Works quite well, actually. I use it all the time. eMail me (address in profile) if you need help.
posted by unclejeffy at 4:38 PM on August 20, 2007