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

Word can support quite elaborate field nesting, but it's not even apparent that's needed here. For your 16 levels, you could have 16 stand-alone IF fields, coded like:
{IF«Score1»= 1 "Text for Score1 1"}{IF«Score1»= 2 "Text for Score1 2"}{IF«Score1»= 3 "Text for Score1 3"}, etc.
{IF«Score2»= 1 "Text for Score2 1"}{IF«Score2»= 2 "Text for Score2 2"}{IF«Score2»= 3 "Text for Score2 3"}, etc.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks Paul, so do I put the text for the 16 scores in the excel document?

You don't! You put them in the IF fields in Word - where the "Text for Score1 1", etc. is indicated.

PS: The IF field and conditions can be input via the 'Rules' dropdown.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks Paul! Sorry for confusion. I'm new to this!