How to Mail Merge Certificates to PDF from Excel

To mail merge certificates, you need two things: a certificate design with empty space where the personal details go, and a spreadsheet with one row per recipient. A mail merge tool writes each row's name, course and date into the design and saves the result as PDF, either one file per person or one combined file for printing. This guide covers every step, from the template and the Excel list to naming the files and emailing each certificate to its recipient.

What you need before you start

A certificate design as a PDF (or a Word file), usually A4 or US Letter in landscape. It contains everything that is the same for everyone: the title, the logo, the wording, the signature lines.
A list of recipients in Excel (.xlsx or .xls), CSV or Google Sheets, with one row per person.
A decision about the output: one PDF per person if you are going to email or archive the certificates, one combined PDF if you are going to print them. Most of the time you want both.

Step 1: Prepare the certificate template

Design the certificate in whatever tool you already use (Canva, Word, PowerPoint, InDesign, Illustrator) and export it as PDF. The important part is what you leave out: the name line, the date and anything else that changes per person stay empty, because the mail merge fills them in later. Static text such as "This certifies that" or "has successfully completed" belongs in the design.

A few details save trouble later:

Leave room for long names. Find the longest name on your list and make sure it fits on one line at your chosen font size.
Center the name area. Centered text stays balanced whether the name is "Li Wei" or "Maximilian Hohenberg-Schwarz".
Use a font with a full character set. Decorative script fonts often lack characters such as é, ø, ł or ğ, and a name printed with a missing glyph looks careless on a certificate.
Use high-resolution artwork if the certificates will be printed, and keep the file size reasonable if they will be emailed.

If your certificate is a fillable PDF form with a text field for the name, you can fill those form fields directly instead of placing text on top of the page. See how auto-filling PDF forms works. No design yet? There are free certificate PDFs at the end of this article.

Step 2: Decide which fields change per person

Every value that differs between certificates becomes a column in your spreadsheet. Typical fields:

Full name, exactly as it should be printed. This is the only field every certificate needs.
Course, event or award title, if the same template is used for more than one.
Date of completion, attendance or issue.
Hours, credits, grade or level, if the certificate states them.
Certificate number, so each certificate can be identified and verified later.
Instructor or signatory, if different people sign for different groups.
Email address. It is not printed, but you need it to send each certificate to the right person.

Anything that is identical for everyone (the organization name, the main signature, the logo) stays in the template, not in the spreadsheet.

Step 3: Set up the Excel list

Put one header row at the top and one person per row below it, for example with the columns FullName, Course, Date, CertificateID and Email. Then clean the list once before you run anything:

One name column, written the way it should appear. "Anna Müller", not "MULLER, ANNA". If your registration export splits first and last name, add a column that joins them.
Write dates as text in their final form, for example "2 October 2026". A cell formatted as an Excel date can come out in a different format or as a number, depending on the tool and regional settings.
No blank rows, merged cells or subtotal lines inside the table. Each row should produce exactly one certificate.
Trim stray spaces and check the spelling of names against your registration data. A certificate makes a typo official.
Give each certificate a unique ID, such as WS-2026-001, WS-2026-002. It doubles as a register of what you issued.

Step 4: Place the fields and preview

Connect the spreadsheet to the template and place each column where it belongs: the name on the name line, the date above the date line, and so on. Set font, size, color and alignment for each field so they match the design. Before generating the whole batch, preview a few rows, and always include the longest name and a name with accents. If those two look right, the rest will too.

Step 5: Generate one PDF per person or one combined PDF

Which output you choose depends on what happens next:

One PDF per person is the right format for emailing, for uploading to a learning platform, or for filing each certificate in a personnel or student record.
One combined PDF, with one certificate per page, is the right format for printing, for sending to a print shop, or for a quick visual check of the whole batch. Printing is covered in detail in our guide to batch printing certificates.

Name the files from your data

Individual files are only useful if you can find them again. Build the file name from your columns instead of accepting a numbered sequence, for example Certificate_{FullName}.pdf, or Certificate_{CertificateID}_{FullName}.pdf if two people on the list could share a name. Add the course or year when you issue certificates regularly, so this year's files don't collide with last year's. Avoid characters that file systems reject, such as / \ : * ? and quotation marks.

Step 6: Email each certificate to its recipient

The last step is sending each PDF to the address in its own row, as an attachment, with a short personal message: "Hello {FullName}, congratulations on completing {Course}. Your certificate is attached." Send from an address the recipients recognize, ideally your organization's own, so the email does not look like spam. Afterwards, check which messages bounced; a mistyped address on the list is the most common reason a certificate never arrives.

The same method for health and test certificates

Clinics, labs, occupational health services and test centres can use exactly the same process for health and test certificates: the template holds the fixed layout and wording, and the spreadsheet holds the patient's name, date of birth, test or vaccination type, date and result. Because this is sensitive data, send each document only to the address on its own row, consider protecting each PDF with a password the recipient already knows, and check which details your local regulations require on the document.

Can you mail merge certificates in Word?

Yes, if the certificate is a Word document. In Word, go to Mailings > Start Mail Merge > Letters, choose Select Recipients > Use an Existing List and pick your Excel file, then place the fields with Insert Merge Field, check them with Preview Results and finish with Finish & Merge > Edit Individual Documents. Dates often come through in the wrong format; press Alt+F9 to show the field code and add a switch such as \@ "d MMMM yyyy" to the date field.

Word has three limits that matter for certificates:

It produces one combined document. Saving each certificate as its own PDF needs a macro or an add-in.
Finish & Merge > Send Email Messages sends the document through Outlook as the email body (or as an attached Word file). It cannot send each person their certificate as a PDF.
It cannot use a PDF as the template. Opening a PDF in Word converts it into an editable document, which often shifts a carefully designed layout.

Mail merging certificates in MailMergic

MailMergic does all six steps in the browser, without Word, Acrobat or a plug-in:

Upload your certificate as a PDF or Word file, or pick one of the ready-made certificate designs in the template gallery.
Add your list from Excel, CSV or Google Sheets.
Drag each column onto the certificate, or match it to a form field, and preview any row. You can upload your own font, and add a QR code generated from each row, for example a link to a verification page.
Generate one PDF per row or a single combined PDF, with file names built from your columns. MailMergic checks the data for missing values before it generates anything.
Download the batch as a ZIP, or email each certificate to the address in its row as an attachment, with a personalized subject and message, sent from your own address. Delivery and bounces are recorded per recipient.

The free plan covers 100 documents a month with a watermark and needs no credit card; the paid plans remove the watermark. Start a certificate mail merge in MailMergic, or see the certificate features first.

If you are issuing course certificates, this checklist of what a certificate of completion should contain helps you get the wording, signatures and IDs right before you generate the batch.

Free certificate PDFs to start from

These 15 certificate designs are A4 landscape PDFs with a blank name line, ready to use as a template: