Copy link to clipboard
Copied
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
Copy link to clipboard
Copied
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).
Get ready! An upgraded Adobe Community experience is coming in January.
Learn more