Training · Bulk Certificate Generator
How to mail merge certificates in Word from Excel
Put recipients in Excel with a header row, design a one-page landscape certificate in Word, then on the Mailings tab use Start Mail Merge, Letters, Select Recipients, Use an Existing List, and Insert Merge Field for Name, Course and Date. Preview Results, then Finish and Merge to print to PDF or edit individual documents.
Prepare the Excel list
Word reads the first row of the sheet as field names and every row below it as a recipient. Keep the list on one sheet, starting at cell A1, with headers such as Name, Course, Date and Score. Microsoft's guidance is that the data be on one sheet and formatted so Word can read it, which in practice means no merged cells, no blank rows inside the list, and no titles above the header row.
Type dates and numbers the way they should print. A true Excel date cell often arrives in Word as 3/4/2026 even if Excel displays March 4, 2026, so either format the column as text or add a helper column with =TEXT(C2,"mmmm d, yyyy"). The same applies to scores: a cell showing 95% may merge as 0.95.
If first and last names are in separate columns, add a FullName column with =A2&" "&B2 so the certificate needs only one field. Save the workbook and close it; Word can read an open workbook on Windows but it causes locking problems on shared drives.
Build the certificate template in Word
Create a new document, set Layout, Orientation to Landscape, and set margins to match the certificate paper. If you have a designed certificate as an image, insert it, set Wrap Text to Behind Text, and size it to the full page. Then add text boxes or centered paragraphs for the fixed wording (Certificate of Completion, This certifies that, has completed) and leave the recipient lines empty for now.
Choose fonts that are installed on the computer that will run the merge, because a missing font substitutes silently. Set the name line large (36 to 48 points is common) and test that the longest name on the list fits on one line at that size; a 32-character name is the usual breaking point.
Save the template as a normal .docx. Word stores the merge connection inside it, so when you reopen the file later it will ask whether to run the SQL command that reconnects to the Excel list; answer yes.
Connect the list and insert merge fields
On the Mailings tab choose Start Mail Merge and then Letters. Choose Select Recipients, Use an Existing List, browse to the workbook, and pick the sheet that holds the names. Confirm the box that says the first row contains column headers. Edit Recipient List lets you untick rows or sort, which is useful when only part of the roster earned a certificate.
Click where the name should print and choose Insert Merge Field, then Name. Repeat for Course, Date and any other field. Each field appears as <<Name>> in the template; format it like ordinary text (font, size, bold, alignment) and the merged text takes that formatting. Put each field in its own paragraph or text box so a long value does not push the rest of the layout down.
Turn on Preview Results and use the arrows to step through several recipients. Check row 1, the last row, and the longest name. Fix any overflow in the template now; nothing is fixable after the merge without rerunning it.
Finish the merge and produce PDFs
Finish and Merge offers three outputs. Edit Individual Documents creates one new Word document with a page (or section) per recipient, which is convenient for a final read-through and for printing on a physical printer. Print Documents sends the merge straight to a printer; if that printer is Microsoft Print to PDF or a similar PDF printer, you can produce PDF output, though some PDF printers put all pages in one file. Send Email Messages sends each recipient a message through Outlook, but only the body, not an attached PDF.
To get one PDF per recipient with the recipient's name as the file name, the reliable route is Edit Individual Documents followed by a short macro that saves each section as a separate PDF using a field for the name. Several published macros do this; the guide from Virtualbadge walks through the Print to PDF option and notes that the process is workable but clunky for certificates, which is a fair description.
If the roster is long or you need named files without a macro, a browser tool such as Benchlet Bulk Certificates takes the same Excel data exported as CSV and returns a ZIP with one PDF per row already named from the name column, which removes the splitting step entirely. Either way, keep the Word template; it is the reusable part.
Common problems and fixes
Fields show as {MERGEFIELD Name} instead of the value: press Alt+F9 to toggle field codes off. Dates merge as serial numbers or raw formats: format the Excel column as text or add a switch to the field code, for example { MERGEFIELD Date \@ "MMMM d, yyyy" }. Leading zeros drop from ID numbers: store them as text in Excel.
The name wraps to two lines: reduce the font size for that field, widen the text box, or use a condensed font. Accented characters print as question marks: save the Excel file normally rather than as an old CSV, or when connecting the CSV choose UTF-8 encoding. Word asks about an SQL command every time the template opens: that is the stored data connection and is expected.
Only some recipients merged: check Edit Recipient List for unticked rows, and check that there is no blank row in the Excel list, which Word treats as the end of data on some versions.
Frequently asked questions
Which merge type should I pick for certificates?
Letters. It creates one page per recipient from a single-page template, which is exactly what a certificate is. Labels and envelopes tile multiple recipients per page.
Can Word save each certificate as its own PDF?
Not from the ribbon alone. Use Finish and Merge, Print to a PDF printer, or Edit Individual Documents followed by a macro that splits sections into named PDFs.
Why does my date print as 3/4/2026?
Word takes the underlying Excel value, not the displayed format. Format the column as text or add a date switch such as \@ "MMMM d, yyyy" to the merge field code.
Does the Excel file need a header row?
Yes. Word uses the first row as the merge field names, so headers such as Name, Course and Date are required and should be short with no punctuation.
Can I email the merged certificates as attachments from Word?
Word's Send Email Messages option sends the merged text as the message body, not as a PDF attachment. To attach PDFs, generate the files first and use an email mail merge that supports attachments.
