Forum Discussion

SM33's avatar
SM33
Copper Contributor
May 10, 2026

MS Word and Excel Mail Merge Certificates (advanced)

I need to run a mail merge (using Word and Excel) for certificates where per Course each student has a unique number of competencies they have achieved, example code attached. I cant manipulate or a...
certificate
excel
mail merge
unique rule use
word
Charles_Kenyon's avatar
Charles_Kenyon
Bronze Contributor
May 11, 2026

Cross-posted at recommendation of Darren Ng. 

https://learn.microsoft.com/en-us/answers/questions/5886294/ms-word-and-excel-mail-merge-certificates-(advance

For cross-posting etiquette, please read: A Message to Forum Cross-Posters

You are likely to get as good an answer there as here.

My response there:

Look into a directory or catalog mail merge.

http://www.msofficeforums.com/mail-merge/38721-microsoft-word-catalogue-directory-mailmerge-tutorial.html

Also consider Doug Robbins' MergeTools. https://mergetoolsaddin.com/