Differing Text Based on Merged Field

  • Thread starter Thread starter CJ
  • Start date Start date
C

CJ

Hi,
I want to create a letter that will contain a list of
subject grades in the left column (that I will merge from
an Excel spreadsheet) and a comment in the right column
(actually I just tabbed over twice) that changes based on
the grade the student received for that subject. Example:

English A Fantastic Job! Keep up the good work. :-)

or

English B Nice solid effort. Next time go for an A! I
know you can do it!

Of course the subject and grade would be listed only once.
What would change would be the comment. I would like to be
able to have a list of five different comments...and the
set of comments would not necessarily be the same from
subject to subject.

It seems the "Insert Word Field", "If...Then...Else"
option only allows you the possibility of two comments.
Can anyone point me in the right direction? TIA

CJ
 
Hi CJ,

You can use:
{IF{MERGEFIELD Score}= "A" "Fantastic Job! Keep up the good work."}
{IF{MERGEFIELD Score}= "B" "Nice solid effort. Next time go for an A!"}
{IF{MERGEFIELD Score}= "C" "Text for C."}
{IF{MERGEFIELD Score}= "D" "Text for D."}
{IF{MERGEFIELD Score}= "E" "Text for E."}
as a seies of IF tests, without the need for the 'else' part.

Alternatively, you could nest the IF tests:
{IF{MERGEFIELD Score}= "A" "Fantastic Job! Keep up the good work."
{IF{MERGEFIELD Score}= "B" "Nice solid effort. Next time go for an A!"
{IF{MERGEFIELD Score}= "C" "Text for C." {IF{MERGEFIELD Score}= "D" "Text
for D." "Text for E."}}}}
but that's a lot harder for most people to understand/maintain.

Cheers
 
In the first example, the series of fields should all follow one another on
the same line, wrapped naturally in Word. This may not be clear due to
wrapping options in the newsreader used to view the message.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Back
Top