Certificates with Word and Excel: the mail merge, honestly explained

The route through Word and Excel has three real strengths. Your data stays entirely in-house, which often tips the balance in government and corporate settings. You need no new software and no approval, Word is already there. And if your attendee list is well maintained anyway, say from a course with fixed registration, the personalization is done in an hour.

The weaknesses gather behind the creation step: when producing individual files, when sending them, and with every correction. More on that below; first the guide.

1. Prepare the Excel list: one row per person, column headers in row 1 (say First name, Last name, Course, Date), no merged cells, no blank rows. Save the file and close it; an open source file likes to block Word.
2. Build the certificate in Word: page format A4 landscape via Layout and Orientation, generous margins, a title, a dedication line and room for the name. Put the name on its own centered line in a suitably large font.
3. Start the mail merge: the Mailings tab, then choose “Start Mail Merge” and “Letters”.
4. Connect the list: “Select Recipients”, “Use an Existing List”, and pick your Excel file and the right worksheet.
5. Insert the fields: cursor at the name spot, “Insert Merge Field”, first First name, a space, then Last name. Do the same for Course and Date in their places.
6. Check several records with “Preview Results”, explicitly including the longest name on the list, more on that in a moment.
7. Produce the documents: “Finish & Merge”, then “Edit Individual Documents” for one combined file with all certificates, or print directly.
8. For PDF: save the combined file as PDF via “Save As”. Careful, that gives you one file with all certificates one after another, not one file per person.

These problems show up reliably. The table saves you the search through forums:

The mail merge carries you up to the finished stack. After that begins the part it was never built for: producing 80 individual files, sending 80 emails each with the right attachment, then three weeks later correcting two names and running the whole round again. And a Word PDF stays a document with no way to verify it: whoever receives it can forward or recreate it, and no one can look up whether it is genuine.

If your attendees are also meant to add the certificate on LinkedIn under Licenses & certifications, the mail merge is missing the decisive piece, the verification address. You cannot attach a PDF there, the form wants a link.

The counter-model to the mail merge drops the list entirely. You design the certificate once, the name field stays fillable, and you share one link: each person enters their own name and downloads their A4 PDF, along with an image for sharing and a verifiable credential link for their profile. Corrections, individual files and sending fall away as tasks, because the method never creates them in the first place.

Both routes side by side, with the situations in which the list approach wins, are on the page Certificates for many attendees. And if what bothers you most about the Word route is the design work: the certificate templates are the part you can also try out on their own.