brad_12 Posted December 15, 2010 Share Posted December 15, 2010 Hi I'm taking over the digital print area here and I have some variable date postcards I need to put addresses on. I just kind of wanted a quick run through of how you would go about that. The mailing list is an excel spreadsheet with each column having name, address, and state and zip. I've watched the guy before me do it, but haven't done it myself. Need help quick! Thanks Link to comment Share on other sites More sharing options...
Dan Korn Posted December 20, 2010 Share Posted December 20, 2010 This is a pretty basic VDP job. The usual way to do this is to export the data from Excel to a tab-delimited file, and import that as a data source into FusionPro. Then you can create a text frame and insert the variable field names for the address data. Take a look at the Cell Phone tutorial. Link to comment Share on other sites More sharing options...
robertg Posted March 23, 2011 Share Posted March 23, 2011 I too have a "basic" VDP job, but I am a brand new FP user. The problem I have is a deadline of this coming Friday morning to get this job out. Here are the specs. I really appreciate someone helping me with this. FP Desktop (purchased and downloaded on 3-16-11) Customer supplied MS Word file and Excell spreadsheet data file. The only Variable Data is the "name, address, city, state, zip" block. The video tutorials were helpful but I feel my tight deadline leaves no room for lost time. Help! Link to comment Share on other sites More sharing options...
Dan Korn Posted March 23, 2011 Share Posted March 23, 2011 FP Desktop (purchased and downloaded on 3-16-11) Customer supplied MS Word file and Excell spreadsheet data file. The only Variable Data is the "name, address, city, state, zip" block Basically what you need to do is save or print the Word document to a PDF, and save the Excel document to a CSV or tab-delimited format, and then open the PDF in Acrobat and click the "big orange F" button, and click through to assign the CSV or tab-delimited file as the flat-file input for the job. Then you can use the "Draw Text Frame" tool to create a variable text frame, and then edit the text to insert the variables from the data. The video tutorials were helpful but I feel my tight deadline leaves no room for lost time. Help! It shouldn't take more than an hour or so to do what I described and play around a bit with the job. Again, the Cell Phone tutorial has an example of a basic address field frame. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.