Forum Discussion
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 add data to the excel content with additional columns.
I need one certificate per student each with their related competency achievement(s).
Has anyone else found a solution without having to use an add in?
Ive seen a template where the creator used the "next if" rule and the "if" condition is if the student ID is equal to, but i cant recreate it.
2 Replies
All of the hard work has been done for you if you use the Many to One facility of my MergeTools Add-in that you can download from:
Extract the files from the archive and read the:
“READ ME – Setting up and using the Merge Tools Add-in.pdf
to see how to install and use the various tools.
Cross-posted at recommendation of Darren Ng.
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/
