Mail merge certificates in Word and Excel: a practical guide
How to mail merge certificates from an Excel list in Microsoft Word, what Word and Gmail can and cannot email, and when a certificate tool saves time.
On this page (6)
Mail merge is the classic way to make certificates for a whole course. You design one certificate in Microsoft Word, connect it to an Excel list of participants, and Word fills in each name. It still works well for printing. Emailing the certificates is where it gets awkward, and this guide explains why.
Prepare your Excel list
Microsoft's own checklist is short and worth following:
- Put all participant data on the first sheet of the workbook.
- Use column headers that match the fields you want on the certificate, for example FirstName, LastName, Course and Date.
- Store the file on your own computer.
- Finish all edits before you connect the list to Word.
Add an Email column too, if you plan to send anything by email later.
Create the certificate in Word
- Open a blank document and set it to landscape. Add your logo, border and the fixed text.
- Go to Mailings and then Start Mail Merge, and choose Letters.
- Choose Select Recipients and point to your Excel file. Use Edit Recipient List to untick anyone who should not get a certificate.
- Click where the name should go and use Insert Merge Field to add FirstName and LastName. Repeat for course and date.
- Format the merge fields the way you want the final text to look. Select a field to change its font or size.
- Choose Preview Results and step through a few participants with the arrow buttons. Check long names and dates.
- Go to Finish & Merge. Here you can pick Edit Individual Documents, Print Documents or Send Email Messages.
Save the main document. It keeps its connection to the Excel file, so you can reuse it for the next course.
Can Word mail merge email the certificates?
Partly, and it depends on your computer. Word's email merge needs a MAPI-compatible email program, such as Outlook, installed on your computer.
On Windows, Microsoft is clear: Word sends an individual message to each address, and you cannot add attachments, only links. The merged text goes into the email body, not into a certificate file.
On Mac, Word can send the merged message as an attachment instead. The email then has no body text, and the merged document travels as the attached file.
So mail merge is very good for printing a stack of certificates and less good for emailing a PDF to each person.
What about Gmail?
Gmail now has its own mail merge for some paid Google Workspace plans (Workspace Individual, Business Standard and Plus, Enterprise Standard and Plus, Education Standard and Plus). You can link a Google Sheet and use merge tags such as @firstname in the message.
It personalises the email, not an attachment. If you attach a file, Google says the same attachment goes into each recipient's copy. Merge tags do not work in subject lines, and each email gets an unsubscribe link added automatically. That fits a newsletter better than a personal certificate.
Where mail merge stops
Even when the merge works, a few things stay manual.
There is no way to check a certificate. A printed sheet or a Word file has no verification page, so an employer who wants to confirm it has to contact you.
Corrections mean a new round. A misspelled name means fixing the Excel row, merging again and sending or printing that person's certificate again.
Sending is still on you. On Windows you attach and send each file yourself. With Gmail you can personalise the text, but not the certificate.
The next step: Diplino
Diplino starts from the same list. Save your Excel sheet as a CSV file and upload it, and each participant gets a personal certificate by email, with your logo and colours. Every certificate has its own verification page and QR code, so anyone can check it is real without asking you. Diplino also sends an automatic reminder to participants who have not opened their certificate, and shows you which emails bounced or were not opened so you can resend them.
If a name is wrong, you correct it and resend. That does not use up a certificate, because there is no fee per certificate. Certificates, emails and the verification page work in nine languages, data is hosted in the EU and every plan includes a DPA.
You can try your design with free sample certificates, as many as you like. They are watermarked and cannot be verified. The Free plan includes 10 real certificates, and paid plans start at 12 EUR a month billed annually.