Batch fill in of pdf forms from excel

[marcinh4948071]

Is there a wasy of using an excel spreadsheet with data (the same fields as the form) to automatically create a number of pdf documents (based on a pdf form)?

Thank you

[try67]

Yes. This is called a Mail Merge. If you have the PDFMaker plugin of Acrobat for Office then you should have this command under the Acrobat ribbon in Excel and in Word.

Another option is to do it directly in Acrobat, using a script, like this (paid-for) tool I've developed which offers some additional features that the PDFMaker plugin doesn't have (custom naming of the output files, automatic emailing, flattening the merged files, output to a single file, etc.): http://try67.blogspot.com/2011/09/acrobat-mail-merge-and-email.html

[marcinh4948071]

Thank you for your reply.

In terms of PDFMaker Plugin, In Excel, I can only see options to create a pdf out of the data in a worksheet, visually  'as is', ie. just a table, not an ability to use pdf forms to be populated with the data from the spreadsheet. Am I missing something?

[try67]

Sorry, my mistake. It seems the Mail Merge option is only available in Word, not in Excel.

[ls_rbls]

hi,

there is a paid-for software for adobe acrobat called Automailmerge.

Since Adobe Acrobat doesn't provide that capability , you may have to go online and purchase it.

[marcinh4948071]

OK. Thank you everyone. I'll have to review the paid options.

[ls_rbls]

You're welcome.

Just so you know Automailmerge is not a third party app. And it costs less than 160 dollars.

AutoMailmerge is developed by EverMap Company which is  an Adobe Technology Partner and memeber of the Creative Cloud Adobe Exhange Program.

[try67]

I believe that still counts as "third-party", since it's not Adobe themselves who developed it...

[Power PDF Filler]

Now there is another option to batch fill PDF forms from Excel, which is Power PDF Filler. It is super easy to use. 

https://appsource.microsoft.com/en/product/office/wa200005545?tab=overview

5 min video: https://youtu.be/w6h7s8COkXA?si=51nZ8kqPYZoUK6lx

[try67]

You forgot to mention this is a paid-for tool...