Mailmerge certain text using multiple if statements

[Debs]

Hi,



I am trying to produce personalised feedback letters for a group of students. In my Excel document is the list of students and their 16 scores going across. There is a different threshold for each of the 16 scores. I have a Word document which has text related to each feedback score. If any of their scores are over the threshold then they should get a paragraph related to that score. Therefore every single student is different. E.g student 1 is above the thresholds for score 1, score 3 and score 14 but student 2 is above the thresholds for score 2, score 5 and score 14.

I've tried it through the rules doing Rule 1 if Score 1 is greater than 3 then insert text. And added another rule if Score 2 is greater than 4 then insert text. But I think there is a Word limit on the text you can insert. It also seems that I can only insert 2 rules when I need to insert 16. I have also been looking at nested IF fields and multiple conditions but getting confused!
Sorry if I've not explained this very well. Be grateful for anyone's help