PDF mail merge

Adobe technically supports mail merge via the PDFMaker plugin in Word, but that requires a full Acrobat Pro subscription — and even then it routes through Word, which often breaks PDF formatting.

I also tried a few online tools like pdfmailmerger, but none of them handled my field mapping correctly.

So I ended up building a Chrome extension for this: PDF Mail Merge — Fill PDF Templates (you can click to try. You upload a PDF template, map fields to CSV/Excel columns, and generate filled PDFs in bulk — all in the browser.

So Acrobat do have this as a feature now.

It is called Mega Sign

https://helpx.adobe.com/sign/using/mega-sign.html#sa_src=web-messaging

Of course, Adobe in their greatness, only support large businesses with their tools - so it is only available to Business and Enterprise level accounts, not individual or small business 😞

I think we should petition Adobe/ Acrobat executives to make Mail merge and API available to individual accounts. Small businesses are the ones that need the most help for time saving tools.

I use this offline tool and it works. It costs a little money though https://plainlab.gumroad.com/l/plainmerge.

You have to our faces the "plug in" for $149

I know the post is like 2 years old, however I found a nice tool which get's the job done quite well: www.pdfmailmerger.com

if someone has the same problem

Instead of purchasing and downloading and installing scripts or plug-ins, the BEST solution I found was simply using Adobe InDesign. I'm not too familiar with InDesign so I was hesitant, but I gave it a try and it works great! I had hundreds of names I needed to import from an Excel spreadsheet onto an award certificate and I exported each into it's own PDF.

The best part is I didn't need to redesign everything in InDesign. I imported my designs (from Illustrator) into my InDesign project without issue. Easy to follow instructions here:

https://helpx.adobe.com/indesign/using/data-merge.html

This video is great too in explaining more of the process:

https://www.youtube.com/watch?v=z1QV6R1y8Y0

I hope this helps others. 

In the past, I have normally used python (via fdfgen and pdftk) to code a solution. Fdfgen can create an FDF file (a specially-formatted filetype that contain the fill data for a pdf form), and pdftk can combine the fdf and form to create a filled-in version of the pdf.

If coding isn't your thing, I have a free site where you can do a mail merge from a spreadsheet and a pdf form at pdfzero.com. Once you upload the PDF form and spreadsheet, you can click on the fields you want to fill in and select the spreadsheet column you want to use for that field. You can also use the spreadsheet data in the filename to keep things organized.

If anyone wishes to perform a bulk merge of data into a PDF form, see this link: http://khkonsulting.com/2015/10/batch-import-excel-data-into-pdf-forms/

I'm looking to do the same.  I found this

Populating PDF Form with Excel Data Using the AutoMailMerge Plug-in for the Adobe Acrobat - YouTube

I'm not trying to sell anything. Wasn't my message. Have a nice day!