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.
