Skip to main content
New Participant
December 3, 2013
Question

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

  • December 3, 2013
  • 7 replies
  • 54644 views

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

This topic has been closed for replies.

7 replies

New Participant
December 10, 2017

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
Community Expert
December 10, 2017

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

Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often
kennethd34797934
New Participant
May 27, 2016

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

try67
Community Expert
May 27, 2016

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.

New Participant
May 26, 2016

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

New Participant
August 21, 2014

Can you please send me the script as well?

try67
Community Expert
August 21, 2014

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

New Participant
March 14, 2014

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

February 4, 2014

Please PM me as well, thanks

try67
Community Expert
February 4, 2014

Done.

try67
Community Expert
December 3, 2013

Possible either with the Mail Merge button in the Acrobat PDF ribbon in some versions of Office and Acrobat, or you'll need to use a script.

New Participant
December 3, 2013

thx, but i can't find mail merge button in acrobat X pro anywhere..hmm. office products irrelevant because i am stuck with a complex pdf document that doesn't convert to word doc correctly so no option to mail merge to pdf from within word. must mail merge excel data list of addresses to the text fields i've setup in the pdf document. why so hard to have mail merge a standard option from within acrobat? this is insane why this full pro version of acrobat doesn't seem to have mail merge function. thx for any help, including if you have access to a mail merge script as you mentioned and then i'd need help using script..never used acrobat scripts. Mike

try67
Community Expert
January 17, 2014

Would you please forward the script to me also ?  Thanks !!


See PM.