Create Multiple Signed PDFs from an Excel-to-Word Mail Merge
Question details
Create separate PDF offer letters from an Excel-to-Word mail merge, with four digital signature fields on each letter.

- Product
- Microsoft Word, Microsoft Excel, and Adobe Acrobat Pro
- Device & OS
- not provided
- Scenario
- Employee offer letters are generated from Excel data in a Word mail merge and need four levels of approval.
- Observed behavior
- Letters are currently converted to PDF individually. The desired workflow would generate multiple PDFs with signature fields in a batch.
Check that the Excel worksheet has a header row and that the Word offer-letter template contains the required merge fields. Confirm that Acrobat Pro and its PDFMaker add-in are available in Word if you plan to use the Adobe PDF mail merge option.
Merge the letters in Word and add signature fields in Acrobat Pro
Use Word and Acrobat to create separate PDF letters, then prepare each PDF for four digital signatures.
Acrobat PDFMaker works with Word mail merges, including merges that use an Excel data source. It does not by itself provide the complete workflow for adding four signature fields to every output file and routing the letters for approval.
In Word, open the letter template and choose Mailings > Select Recipients > Use an Existing List. Select the Excel workbook and the worksheet containing the employee records.
Use Mailings > Insert Merge Field to place employee details, then select Preview Results to check several records and confirm that each letter has space for four signatures.
If available, open the Adobe PDF tab in Word and choose Mail Merge to create PDF files from the merged records. Follow the prompts to select the records and output location. If the option is unavailable, use a suitable mail-merge tool or script to produce separate PDFs.
Open a generated PDF in Acrobat Pro, select Prepare a form, and use the digital signature field tool to place four fields. Give each field a distinct name for its approval level, save the PDF, and repeat for the other files unless you have a tested automation method.
Open a prepared PDF and test the signature fields with the intended signers. Confirm that the fields and signing order work with your approval process before distributing the remaining letters.

Automate PDF creation and field placement with a custom tool
Use a script or specialized mail-merge tool when the number of letters makes manual field placement impractical.
Prepare offer-letter documents with WPS Office
WPS Office is a free, lightweight alternative for working with spreadsheets, documents, and PDFs in a familiar interface. Its Microsoft Office format compatibility can help you move existing files into your workflow, although it does not fix Acrobat's batch-signature workflow.

Frequently Asked Questions
Can a Word mail merge use an Excel spreadsheet as its data source?
Yes. In Word, choose Mailings > Select Recipients > Use an Existing List, select the Excel workbook, and choose the worksheet with your records.
Where is Acrobat's mail merge to PDF option?
When the Acrobat PDFMaker add-in is installed and supported in Word, look on the Adobe PDF tab for Mail Merge. Availability can depend on your Acrobat and Word installation.
Does adding four signature fields automatically sign each letter?
No. In Acrobat Pro, Prepare a form lets you add digital signature fields, but each intended signer must apply their own signature. Routing approvals may require a separate service.
Can I add the same four signature fields to every PDF automatically?
A tested script or specialized PDF automation tool may be able to add named fields to each file. Check the tool's capabilities and test field positions in Acrobat Pro before running a full batch.
What if the Adobe PDF mail merge option is missing in Word?
Check whether Acrobat Pro and its PDFMaker add-in are installed and enabled in Word. If the option remains unavailable, use another suitable mail-merge tool or script to generate separate PDFs.




