How to Perform a Mail Merge in Adobe Acrobat Pro DC
Question details
The user needs to combine spreadsheet data with a PDF containing fixed and variable content to create customized documents.
- Product
- Adobe Acrobat Pro DC
- Device & OS
- not provided
- Scenario
- Generating multiple customized PDF documents from an Excel spreadsheet, CSV file, or database using a mail merge process.
- Observed behavior
- Acrobat Pro DC does not provide a simple standalone mail-merge workflow out of the box, requiring users to rely on alternative methods like the PDFMaker plug-in or JavaScript tools.
Ensure you have your data source prepared as a CSV or Excel file, and verify that Microsoft Word or Excel is installed alongside Acrobat Pro DC to utilize the PDFMaker plug-in.
Use the Acrobat PDFMaker Plug-in in Microsoft Word
The most straightforward way to mail merge to PDF is to set up a standard mail merge in Word and use the Acrobat PDFMaker tab to output directly to PDF files.
This method leverages Microsoft Word's native Mailings feature combined with Acrobat's conversion engine to generate high-quality PDFs. It allows you to output individual PDFs per record, name them automatically, and even email them directly.
Open Microsoft Word and set up your mail merge document by connecting it to your Excel or CSV data source using the 'Mailings' tab and selecting 'Select Recipients'.
Click 'Insert Merge Field' on the Mailings ribbon to place the necessary data placeholders into your document where the variable data should appear.
Instead of clicking 'Finish & Merge' in the Mailings tab, go to the 'Acrobat' tab on the Word ribbon and click the 'Merge to Adobe PDF' button.
In the dialog box that appears, choose whether to create a single combined PDF or individual PDFs for each record. You can also set custom file names based on data fields and optionally configure email settings to distribute the results.
Use an Acrobat JavaScript-based Mail Merge Tool
For users needing to merge data directly into existing PDF forms without using Word, third-party JavaScript tools or custom Acrobat scripts can be used.
Perform Mail Merges Effortlessly with WPS Office
WPS Office provides a streamlined mail merge process within its Writer application, allowing you to easily generate multiple customized documents and export them directly to PDF without needing complex plugins or custom scripts.
- 1. Open WPS Writer: Launch WPS Writer and open your template document.
- 2. Start Mail Merge: Go to the 'References' tab, click on 'Mail Merge', and select 'Open Data Source' to link your spreadsheet containing the records.
- 3. Insert Fields: Click 'Insert Merge Field' to place your variable data placeholders accurately within your document text.
- 4. Export to PDF: Click 'Merge to Different New Document' to generate the compiled file, then use the built-in 'Export to PDF' feature under the 'Menu' tab to save your merged files as high-quality PDFs.
Frequently Asked Questions
Can I mail merge directly within Acrobat Pro DC without using Microsoft Word?
Acrobat Pro DC does not have a native, built-in mail merge wizard like Microsoft Word. You must either use the PDFMaker add-in in Word/Excel, or rely on custom JavaScript tools and Action Wizard scripts to merge tab-delimited data directly into PDF forms.
Why is the Acrobat tab missing in Microsoft Word?
The PDFMaker add-in might be disabled or not installed correctly. To fix this, open Word, go to File > Options > Add-ins. At the bottom, manage 'COM Add-ins', click 'Go', and check the box next to 'Acrobat PDFMaker Office COM Addin'.
How do I separate mail merge PDFs into individual files?
When using the 'Merge to Adobe PDF' button in Word via the Acrobat tab, a dialog box will appear allowing you to specify the output options. You can choose the option to generate individual PDF files for each record and specify a data field to name them.
Does the Acrobat mail merge process support emailing the PDFs directly?
Yes, the Acrobat PDFMaker plug-in for Word allows you to directly email the generated PDFs. In the 'Merge to Adobe PDF' dialog box, you can select an email address field from your data source, enter a customized subject line, and send the personalized PDFs as attachments.
