You do this for every record you have in your Excel file and save the PDF file to a new name. This will fill the PDF form with the selected values: Press Browse to select a data file: EVERMAP HOW TO MAIL MERGE PDF DOCUMENTS 14. On the next screen you can then pick which record to import, you can only import one record at a time: Step 5: Now click the Select Recipients option, as well as select your data source (Excel File or CSV). On the file dialog, select to import a text file, browse to your exported text file and select it. Step 1: Open Word and prepare your mail merge PDF. Once you have your Tab Delimited Text file, open your PDF form, and select Tools>Forms>More Form Options and click on Import: Instead of selecting Finish and Merge, select Merge to Adobe PDF. Click on Select Recipients and choose your data source (CSV or Excel File) Click on Insert Merge Fields and customize the document as desired. This is one of the export options in Excel (and other spread sheet applications) that is available after you select File>Save As: Go to Mailings tab -> Click on Start Mail Merge and then Select Letters. When you export your data file from Excel, you need to select the 'Tab Delimited Text' format. In this sample, I took the first approach and used the field names as my column headers: You can either match the names that you are using in your PDF form, or you need to modify the field names in the PDF form so that they match the column names in Excel. The columns need to be named the same way as the field names in the PDF form. Thanks for trying to help.Yes, but you there are two things you need to do in Excel for this to work: Out my own Windows pc to continue, wish I had done that from the start. Apparently PDFmaker IS compatible with Word 2016 for Mac (which is why I spent so long trying to get it to work), but is NOT compatible with Mac OS (which makes absolutely no sense to me, but I suppose I'm not a programmer).

I've spoken to both MS and Adobe support and both finger the other party as the one I should talk to for support. I have about 900 personalized certificates to send to specific emails, so I need to figure out how this can be done. I've also tried reinstalling both softwares, restarting, etc. I have tried equipping all three add-ins by Adobe, and none seem to have made this button appear. However, the 'Merge to Adobe PDF' button does not seem to exist on Macs, even though as far as I can tell, Adobe PDFmaker is compatible with Word 2016 for Mac ( ). I'd like to execute a mail merge that will generate personalized PDFs and send them to the appropriate address, as is outlined in this tutorial:

Pdf mail merge excel mac