PDF Conversion Issues

Create Multiple Signed PDFs from an Excel-to-Word Mail Merge

Olivia MillerOlivia Miller Nov 18, 2026 868 views

Question details

Create separate PDF offer letters from an Excel-to-Word mail merge, with four digital signature fields on each letter.

Create Multiple Signed PDFs from an Excel-to-Word Mail Merge
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.
Before you start

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.

Solution 1Recommended

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.

1
Connect the Excel data

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.

2
Check the merged letters

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.

3
Generate separate PDFs

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.

4
Add digital signature fields

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.

5
Test the approval process

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.

Merge the letters in Word and add signature fields in Acrobat Pro
Signature fields are not signatures: Adding a digital signature field creates a place to sign; each approver must still apply their own signature. Approval routing may require a separate signing service or workflow.
Free Microsoft Office alternative

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.

Work with employee data and offer-letter documents in one office suiteOpen and edit Microsoft Excel XLSX and Word DOCX filesUse a familiar interface when moving from Microsoft OfficeAccess PDF tools alongside documents and spreadsheets
microsoft office alternative - wps office

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.