Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
1

Excel Tables in PDF Forms?

New Here ,
Jun 10, 2020 Jun 10, 2020

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.

TOPICS
Create PDFs , How to , PDF forms
3.1K
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jun 10, 2020 Jun 10, 2020

Not possible.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jun 23, 2020 Jun 23, 2020

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.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jun 23, 2020 Jun 23, 2020
LATEST

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

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines