![]() |
|
#1
|
||||
|
||||
![]()
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}"}
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#2
|
|||
|
|||
![]()
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 |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Jamal NUMAN | PowerPoint | 5 | 03-20-2018 12:14 AM |
![]() |
emtmike | Word | 1 | 10-09-2012 12:23 AM |
![]() |
Jamal NUMAN | Excel | 9 | 09-02-2011 02:08 AM |
![]() |
AwesomeOpportunities | Outlook | 1 | 07-25-2010 05:08 PM |
Problem with mailing in word | gfr | Word | 0 | 03-17-2010 05:12 AM |