How to mail merge certificates without Word
You can skip Word mail merge when the job is a certificate batch. Upload the same spreadsheet to sheetcerts, edit a certificate template with fields such as {{name}}, and download one file per row. Word is not required and is not opened.
What you are replacing
Word mail merge fills a document from a data source, then you print or save the result. sheetcerts does the fill step for a certificate layout and gives you a ZIP. It does not edit a DOCX and it does not drive a printer dialog for you.
Fields instead of merge fields
Where Word uses merge fields, this editor uses {{name}}, {{course}}, {{date}}, {{hours}}, {{organization}}, and any other header in braces. The insert control adds them so you do not have to type the braces.
What you still do yourself
You still write the sentence, choose the paper, and send the files. You send the files yourself. There is no connection to Outlook or Gmail.
Steps
- 1.Keep the spreadsheet you already have. The same list you would have attached as a Word data source can be uploaded as CSV or Excel.
- 2.Pick a starting template. Eight layouts are included. Editing changes that copy for your batch. Saving the result is included with Pro and Team.
- 3.Insert columns. Put {{name}} on the recipient line and other columns in the body and signer lines.
- 4.Download the ZIP. You get separate files, which is often easier to send than one long merged document.
Free covers 10 certificates per batch, with a small sheetcerts mark. Batch pass is $5 once for up to 200, without the mark. Pro is $19 a month or $190 a year, up to 500 a month, with saved templates. Team is $39 a month or $390 a year, up to 3,000 a month, with a public check page.
Open the editor and bring your spreadsheet.
Questions
Can I upload a DOCX template?
No. Templates are edited in this site. They are not Word files.
Will fonts match a Word document I used before?
No. Certificate text uses a fixed set of Noto Sans and Noto Serif files so accents can embed in the PDF.
Is this the same as a Microsoft mail merge?
No. It is a different tool aimed at certificates. See the comparison page for what each one actually does here.