As Creative Director in a corporate environment, I've dabbled with variable data off and on for several years. From PURLs, to customized datasheets and several project in between. I have a project I'm trying to complete now, and while it's currently working, I need to find an easier way.
Ultimately the goal is to populate a document with personal data from an Excel spreadsheet and send it off to our printer who has an Indigo. Currently, I have the document created in InDesign with variable fields (images and data). We do a little tweaking in Excel to adjust the data some, then we merge it in INDD. THEN, from INDD we export a PDF of all pages and send that off to our printer.
It works quite well, but I'd like to extract myself from the process so that when our group generates the XLS file, they can do something simple (without the need for InDesign) and then send the results off to our vendor. I'm oversimplifying a bit, but hopefully you get the basics. We initially looked at a well-known vendor for some help with this (I won't say who, because it's really not their fault it didn't work as well as I'd like). One of the problems I saw with using them was that THEY created the template, and for us to make any changes, we'd have to repeatedly go back to them. I'd like to have total control in-house.
Thoughts? Any help would be appreciated.
Ultimately the goal is to populate a document with personal data from an Excel spreadsheet and send it off to our printer who has an Indigo. Currently, I have the document created in InDesign with variable fields (images and data). We do a little tweaking in Excel to adjust the data some, then we merge it in INDD. THEN, from INDD we export a PDF of all pages and send that off to our printer.
It works quite well, but I'd like to extract myself from the process so that when our group generates the XLS file, they can do something simple (without the need for InDesign) and then send the results off to our vendor. I'm oversimplifying a bit, but hopefully you get the basics. We initially looked at a well-known vendor for some help with this (I won't say who, because it's really not their fault it didn't work as well as I'd like). One of the problems I saw with using them was that THEY created the template, and for us to make any changes, we'd have to repeatedly go back to them. I'd like to have total control in-house.
Thoughts? Any help would be appreciated.