#1
|
|||
|
|||
Mailmerge certain text using multiple if statements
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 |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
Thanks Paul, so do I put the text for the 16 scores in the excel document?
|
#4
|
||||
|
||||
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] |
#5
|
|||
|
|||
Thanks Paul! Sorry for confusion. I'm new to this!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple If statements, | Jamal NUMAN | Excel | 16 | 11-15-2022 11:59 PM |
Multiple If statements | bremen22 | Excel | 2 | 10-15-2013 06:37 AM |
Mailmerge to Email with a mailmerge attachment | Baldeagle | Mail Merge | 8 | 02-11-2013 04:40 AM |
Mailmerge to Email with a mailmerge attachment | Baldeagle | Mail Merge | 13 | 05-29-2012 02:04 PM |
How do you add text to email mailmerge? | DerekScambler | Mail Merge | 10 | 04-19-2011 05:30 AM |