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

Is there a way to create multiple PDFs from a single form with input data from Excel

New Here ,
Jul 09, 2024 Jul 09, 2024

Basically, every month I want to create a single form and automatically input two points of data (two names) from list with two points of data (excel or somewhere else, I can work around) to create a ton of copies of that form with info input from that source.

 

More specifically: I have a form I need to customize every month. A reflection of every day a process needs to be done and when it doesnt. I want to create one form, and have it automatically fill in [Location name] and [specific unit] to create as many PDFs as need (hundreds, but i can break the lists into smaller stacks). I would have a list of those two points of data and I want it to input them automatically and create as many PDFs as points of data so it becomes something I can easily print and post places.

 

Inversely I can create how ever many copies of the form as PDFs, is there a way to automatically fill out forms with a list of 100s of different variables?

 

Is this a posibility or do I need to come up with a new strategy?

 

Thank you,

Eva

TOPICS
Create PDFs , How to , PDF
981
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 ,
Jul 09, 2024 Jul 09, 2024
LATEST

Yes, this process is called a Mail Merge and it can be achieved using a script, such as this (paid-for) tool I've developed:

https://www.try67.com/tool/acrobat-mail-merge-and-email-pdf-files

You will just need to save the Excel file as a plain-text file (or a CSV file) and then you'll be able to merge it with the PDF form template. You can even email the merged files to the recipients automatically, if you wish (although you don't have to, of course).

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