Excel Tables in PDF Forms?
Copy link to clipboard
Copied
I am working with Adobe Acrobat Pro DC. I am trying to create a PDF form to merge with an Excel table to pre-populated specific fields in my form. This will be similar to performing mail-merge in Windows. The remaining fields will be populated by users. I am working with medical claims and have tables of claims data that I need to insert in the form. The rows in this table can vary according to how many line items are there in each claim. Can I insert an Excel table into a PDF form, like a sub-table that can shrink, or grow in accordance with how many rows are there? If this is possible, how can it be done? Any suggestions or assistance will be greatly appreciate.
Copy link to clipboard
Copied
Not possible.
Copy link to clipboard
Copied
OK, so I've made a PDF form in Acrobat Pro DC that has form fields to merge data from an excel spreadsheet. I am merging one record per Excel row to give me one form per row. Within the form there are some fields that won't be prepopulated so the user can perform data entry. I was trying to follow a tutorial/example I found to create the merge, but the example requires one to use a plug & play to perform the merge and my acrobat does not have this feature. Is it possible to mailmerge like this with Acrobat PRO DC? I am trying to create one formatted template to build forms for partial data entry where I don't have to go through multiple pages having to format multiple fields prior to use. Please advise as any assistance will be greatly appreciated. Thanks.
Copy link to clipboard
Copied
You can do Mail Merge using the Acrobat PDFMaker plugin in Word or by using a script, like this (paid-for) one I've developed: http://try67.blogspot.com/2011/09/acrobat-mail-merge-and-email.html

