Fix Word Mail Merge to PDF Creating Single File Instead of Per-Recipient

When you run a mail merge in Word and try to save the result as a PDF, the default behavior creates one large PDF containing all records combined. This happens because the Save As PDF option in Word treats the merged output as a single document, not as separate files per recipient. You need each recipient to receive their own individual PDF file. This article explains why Word produces a single PDF and provides two reliable methods to generate per-recipient PDF files from a mail merge.

Why Word Merges All Recipients Into One PDF

Word’s mail merge feature is designed to produce a single output document. When you choose Finish & Merge and then select Print or Save As PDF, Word applies the merge to all records and outputs one combined file. This is the expected behavior for printing envelopes or mailing labels, but it is not ideal when you need to send each recipient a unique PDF attachment.

The root cause is that Word does not have a native per-recipient PDF export option. The Save As dialog treats the merged document as a single entity. To get one PDF per recipient, you must either split the combined PDF after the merge or use a method that exports each record individually.

Method 1: Split the Merged PDF Manually or With a Macro

This method uses Word’s built-in Edit Individual Documents feature to create one combined Word document, then saves it as a PDF and splits the PDF into separate files. It works without additional software but requires manual effort for large merges.

1. Complete the mail merge setup
   Ensure your data source is connected and the merge fields are placed correctly in the document. Preview the results to confirm the merge will work.
2. Choose Finish & Merge > Edit Individual Documents
   On the Mailings tab, click Finish & Merge, then select Edit Individual Documents. In the dialog, choose All and click OK. Word creates a new document with one page per recipient.
3. Save the merged document as a PDF
   Go to File > Save As, choose PDF as the file type, and save the merged document. Name it something like “MergedOutput.pdf.”
4. Split the PDF into separate files
   Use Adobe Acrobat Pro’s Split Document tool, a free online PDF splitter, or a third-party PDF editor. Upload the single PDF and split it by page count (one page per recipient) or by bookmark. Save each split file with the recipient’s name or ID.

Limitation: This method is time-consuming for merges with more than 20 recipients. You must name each file manually unless you use a PDF tool that supports batch renaming.

Method 2: Use a VBA Macro to Export Each Record as a Separate PDF

A VBA macro automates the entire process. It loops through each mail merge record, creates a temporary document for that record, saves it as a PDF with a custom filename, and closes the document. You need to enable macros in Word and paste the code into the Visual Basic Editor.

1. Open the Visual Basic Editor
   Press Alt+F11 in Word. In the left pane, right-click Normal, select Insert > Module. A new code window opens.
2. Paste the macro code
   Copy and paste the following code into the module window:
   Sub MergeToIndividualPDFs()
Dim i As Integer
Dim docMain As Document
Dim docTemp As Document
Dim strPath As String
Dim strName As String
Set docMain = ActiveDocument
strPath = "C:\PDFs\" ' Change to your folder
With docMain.MailMerge
.Destination = wdSendToNewDocument
.SuppressBlankLines = True
For i = 1 To .DataSource.RecordCount
.DataSource.ActiveRecord = i
.Execute Pause:=False
Set docTemp = ActiveDocument
strName = docTemp.MailMerge.DataSource.DataFields("FirstName").Value & "_" & docTemp.MailMerge.DataSource.DataFields("LastName").Value & ".pdf"
docTemp.ExportAsFixedFormat OutputFileName:=strPath & strName, ExportFormat:=wdExportFormatPDF
docTemp.Close SaveChanges:=wdDoNotSaveChanges
Next i
End With
MsgBox "Done!"
End Sub
3. Modify the folder path and field names
   Change C:\PDFs\ to the folder where you want the PDFs saved. Replace FirstName and LastName with the actual merge field names from your data source. Use the field names exactly as they appear in the Insert Merge Field list.
4. Run the macro
   Close the editor, return to your main mail merge document (not a merged one). Press Alt+F8, select MergeToIndividualPDFs, and click Run. Word creates one PDF per recipient in the specified folder.

Note: The macro uses the ExportAsFixedFormat method, which requires Word 2010 or later. The PDFs are named using the first name and last name fields separated by an underscore. Adjust the naming logic inside the macro if you need a different pattern.

Common Issues When Saving Mail Merge as Per-Recipient PDFs

The macro returns a runtime error 5630

This error occurs when the macro tries to access a data field that does not exist in the data source. Verify that the field names in the macro match exactly what you see in the Insert Merge Field list. Also ensure the data source is connected and contains records.

Word creates a PDF for each record but the content is blank

The macro might be executing the merge on the wrong document. Make sure you run the macro while the main mail merge document (with the merge fields) is active, not a previously merged document. Also check that the data source is not filtered or sorted in a way that excludes records.

The merged PDFs have extra blank pages

This is often caused by page breaks or section breaks in the mail merge document. Remove any unnecessary page breaks after the merge fields. Alternatively, set the document to shrink content to fit one page using File > Print > Scale to Paper Size.

Manual vs Automated PDF Output From Mail Merge

Item	Manual Split After Merge	VBA Macro Automation
Time required for 100 records	30–60 minutes	2–5 minutes
Software needed	Word plus a PDF splitter	Word only (VBA enabled)
File naming control	Manual renaming required	Customizable via code
Error risk	High (manual mistakes)	Low if code is correct
Skill level required	Basic Word and PDF tool use	Basic VBA familiarity

You now have two ways to create per-recipient PDF files from a Word mail merge. Start with the manual split method if you have fewer than 20 recipients and no coding experience. For larger merges, use the VBA macro to save time and avoid manual errors. If you prefer a no-code solution, consider a third-party add-in like Mail Merge Toolkit, which adds a dedicated “Save as Individual PDF” button to the Mailings ribbon.