Hi everyone,
I've started to use mail merge, so a new opportunity to meet people..

I'm trying to see how I could perform the following task:

I've got an excel file with (unsorted list) names of students who have achieved Level 1 or Level 2 or ...Level 6

I've got different design of certificates in one word file (Level 1 to Level 6)

How can I print with mail merge the adequate certificates for each students

Name of student 1 got level 1 => print 1st certificate with the name
Name of Student 2 got level 2 => print 2nd certificate with the name
...
name Student 45 got level 1 => print 1st certificate with the name

I've tried to use {SKIPIF {MERGEFIELD Level} <> 1} at the beginning of 1st page then {SKIPIF {MERGEFIELD Level} <> 2} on page 2 etc...

but it doesn't work ...there is a kind of conflict between the conditions..


thank you for your support