Word Mailing - conditionally adding information

[swap2688]

I have the following result table in excel where compulsory subjects are (Science & maths) and (English & Marathi) are two optional subjects
Seat No Science Maths English Marathi
1 23 25 30 #
2 26 24 # 30

now in word mailing, i have the following table
Seat No. Course Overall
<<Seat_No>> <<Subject>> <<Marks>>

Here if the student has selected optional subject English than automatically the subject English should come and corresponding marks and vice versa for Marathi.
So is there a way to do this in the mailing.
thank you.

[macropod]

Try employing an IF test. For example:
{MERGEFIELD Seat_No} Science: {MERGEFIELD Science}
{MERGEFIELD Seat_No} Maths: {MERGEFIELD Maths}
{MERGEFIELD Seat_No} {IF{MERGEFIELD English}= "#" "Marathi: {MERGEFIELD Marathi}" "English: {MERGEFIELD English}"}

[swap2688]

how to do it for the following
Say there are three 3 optional papers

O7 O8 O9
Eco # # 10
Pol 12 # #
Psy # 13 #

=IF(AND(J4="#",K4="#"),"Psy",IF(J4="#","Pol","Eco" ))

how to use "AND" in word mail merger.
thank you

[macropod]

You'd use an IF test for each option:
{IF{MERGEFIELD Eco}<> "#" "Eco: {MERGEFIELD Eco}"}{IF{MERGEFIELD Pol}<> "#" Pol: {MERGEFIELD Pol}{IF{MERGEFIELD Psy}<> "#" Psy: {MERGEFIELD Psy}

You can't use the AND test that way.