How to save a mail merge as individual PDF files

Word's Save as PDF turns the whole merged document into one PDF with 200 pages in it. What you usually want is 200 PDFs, each named after the person it belongs to. Word will not do that on its own.

What Word actually gives you

Finish the merge, then File → Save As → PDF, and you get a single PDF containing every record back to back. There is no "one PDF per record" option anywhere in the dialog, and there never has been. If you only need a handful, you can export page ranges one at a time — Options → Page(s) From/To — but that falls apart as soon as a record runs onto a second page.

Saving as individual PDF documents with a specific name

The full request is usually two things at once: split the merge into separate PDF documents, and give each one a name from the data. Word does neither. The routes below cover both.

The macro route

The standard answer is a VBA loop that walks the merged document and exports each section with ExportAsFixedFormat:

out.ExportAsFixedFormat _
    OutputFileName:=folder & name & ".pdf", _
    ExportFormat:=wdExportFormatPDF

It works, and it is free. Before you commit an evening to it, know what you are signing up for:

• Filenames have to come from somewhere. Most published macros ask you to add helper columns to your data — typically DocFolderPath, DocFileName, PdfFolderPath, PdfFileName, spelled exactly — and read the names from those.
• Records that spill onto a second page break any logic that assumes one page per record. You have to split by section, not by page.
• Macros are disabled by policy on a lot of corporate machines, and this is not the sort of request IT approves quickly.
• It is Windows desktop Word only. Word for Mac's VBA is not identical, and Word on the web has no VBA at all.

The add-in route

A free add-in from a Word MVP adds "Merge to Individual Documents" to the ribbon and can output PDF with names taken from a merge field. If you are on Windows, have desktop Word, and are allowed to install things, this is a solid answer and you should use it.

If any of those three is false, skip to the next section.

Skip the merge entirely

All the friction above comes from making one big document first and then trying to cut it up. Going straight from template to files removes the step that causes the problem.

Docs from Excel takes your spreadsheet and one line saying what the documents are, and gives back one PDF per row, each named from a column you choose. Bring your own .docx template if you have one — variable bits written as {{Customer}}, {{Amount}}, {{Date}} — and it is used as-is. It runs in the browser, so there is nothing to install and nothing for IT to approve.

Conversion is done by LibreOffice on the server, so the PDF matches the layout of your Word template rather than being re-drawn by something that guesses at your fonts.