Mail merge data/list from excel to existing pdf document that has text fields for address created

[mford_eugene]

Mail merge data/list from excel to existing pdf document that has text field created for addresses for direct mail purposes

[Thom Parker]

This issue is not suitable for a forum. You need to speak to a consultant.   

[try67]

So the only issue is the files don't have fields? Then the location for each value will need to be provided using XY-coordinates to the tool (or be hard-coded into it), but it's still doable. If you're interested in hiring a professional to create such a script/stand-alone tool for you, feel free to contact me privately.

[Guest]

Please PM me as well, thanks

[try67]

Done.

[aspiegel17]

Could you send me the script as well? Need to mail merge excel and PDF file but have never used scripts before. Thanks!

[merrymary1995]

Can you please send me the script as well?

[try67]

I'm not sending this script to anyone. You can get it from the link posted above.

[Ahmed57]

I appreciate very much if you can send me this script as well

[kennethd34797934]

I would like a copy as well. Would you please send me one? Thank you.

[try67]

Once and for all, I'm not sending a copy of this script to anyone. If you want it you can purchase it using the link provided above.

[robk54044128]

Hey OP, hopefully this answers your question and doesn’t cost $99

Import data from Excel into fillable pdf using Acrobat XI Pro - is it possible? How?

[Thom Parker]

The technique outlined in that discussion is manual. You have to repeatedly perform the import, each time selecting a new row.  Works fine if all you need is one line. Of course if that line is 100 deep into the CSV you'll need to search for it as well.

However, I thought this discussion was about mail merge, which implies creating a new PDF for each row in the Excel file. What is your solution to that Mr robk54044128?  If there is a thousand lines do you suggest manually importing 1000 times?  And how long would that take? How much would it cost your company to have you spend hours clicking buttons in Acrobat. Much more than $99 I suspect. Unless of course you work for free.

The only solution is to either write a script, plug-in, or app yourself, or if you lack the skills, then to purchase a 3rd party product, of which there are many.

The script is actually simple, and you'll find various example and tutorials on it here:

https://www.pdfscripting.com/public/ExcelAndAcrobat.cfm