Batch fill in of pdf forms from excel

Forum|Forum|6 years ago
January 19, 2020
1 reply
11530 views

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

Create PDFs

This topic has been closed for replies.

try67

Community Expert

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

M

marcinh4948071Author

New Participant

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

Community Expert

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

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded