Word Mail Merge OR Query

[Matt Volatile]

Dear All,

Can anyone help me simulate an OR command in a Mailmerge field, please? I
can't quite seem to get my head around the required syntax.

I currently have the following command:

[ IF [MERGEFIELD Booker_Booking_Method ] = "Manual Invoice" "AAHCONF/09/[
MERGEFIELD "unique_ID" ]/[ MERGEFIELD "membership_no" ]" "N/A" ] to produce
invoice numbers on receipts. (with curly brackets, of course).

I need to an a simulated OR clause that also returns the invoice number if
Booking_method equals "Online Invoice". Where do I nest the command?

Thanks in advance for your help!

 

[Graham Mayor]

One way would be with a nested field

{ IF{ MERGEFIELD Booker_Booking_Method } = "Manual Invoice" "AAHCONF/09/{
MERGEFIELD "unique_ID" }/{ MERGEFIELD "membership_no" }" "{ IF{ MERGEFIELD
Booker_Booking_Method } = "Online Invoice" "AAHCONF/09/{ MERGEFIELD
"unique_ID" }/{ MERGEFIELD "membership_no" }" "N/A" }"}

or a calculated field

{ IF{ =({ IF{ MERGEFIELD Booker_Booking_Method } = "Manual Invoice" 1 0} +
{ IF{ MERGEFIELD Booker_Booking_Method } = "Online Invoice" 1 0})} = 1
"AAHCONF/09/{ MERGEFIELD "unique_ID" }/{ MERGEFIELD "membership_no" }"
"N/A" }

(see http://www.gmayor.com/formatting_word_fields.htm )

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Matt Volatile]

Thank you so much, Graham. That's worked like a charm!

One way would be with a nested field

{ IF{ MERGEFIELD Booker_Booking_Method } = "Manual Invoice" "AAHCONF/09/{
MERGEFIELD "unique_ID" }/{ MERGEFIELD "membership_no" }" "{ IF{ MERGEFIELD
Booker_Booking_Method } = "Online Invoice" "AAHCONF/09/{ MERGEFIELD
"unique_ID" }/{ MERGEFIELD "membership_no" }" "N/A" }"}

or a calculated field

{ IF{ =({ IF{ MERGEFIELD Booker_Booking_Method } = "Manual Invoice" 1 0} +
{ IF{ MERGEFIELD Booker_Booking_Method } = "Online Invoice" 1 0})} = 1
"AAHCONF/09/{ MERGEFIELD "unique_ID" }/{ MERGEFIELD "membership_no" }"
"N/A" }

(see http://www.gmayor.com/formatting_word_fields.htm )

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Dear All,

Can anyone help me simulate an OR command in a Mailmerge field,
please? I can't quite seem to get my head around the required syntax.

I currently have the following command:

[ IF [MERGEFIELD Booker_Booking_Method ] = "Manual Invoice"
"AAHCONF/09/[ MERGEFIELD "unique_ID" ]/[ MERGEFIELD "membership_no"
]" "N/A" ] to produce invoice numbers on receipts. (with curly
brackets, of course).

I need to an a simulated OR clause that also returns the invoice
number if Booking_method equals "Online Invoice". Where do I nest the
command?

Thanks in advance for your help!

 

[Graham Mayor]

You are welcome

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Thank you so much, Graham. That's worked like a charm!

One way would be with a nested field

{ IF{ MERGEFIELD Booker_Booking_Method } = "Manual Invoice"
"AAHCONF/09/{ MERGEFIELD "unique_ID" }/{ MERGEFIELD "membership_no"
}" "{ IF{ MERGEFIELD Booker_Booking_Method } = "Online Invoice"
"AAHCONF/09/{ MERGEFIELD "unique_ID" }/{ MERGEFIELD "membership_no"
}" "N/A" }"}

or a calculated field

{ IF{ =({ IF{ MERGEFIELD Booker_Booking_Method } = "Manual Invoice"
1 0} + { IF{ MERGEFIELD Booker_Booking_Method } = "Online Invoice"
1 0})} = 1 "AAHCONF/09/{ MERGEFIELD "unique_ID" }/{ MERGEFIELD
"membership_no" }" "N/A" }

(see http://www.gmayor.com/formatting_word_fields.htm )

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Dear All,

Can anyone help me simulate an OR command in a Mailmerge field,
please? I can't quite seem to get my head around the required
syntax.

I currently have the following command:

[ IF [MERGEFIELD Booker_Booking_Method ] = "Manual Invoice"
"AAHCONF/09/[ MERGEFIELD "unique_ID" ]/[ MERGEFIELD "membership_no"
]" "N/A" ] to produce invoice numbers on receipts. (with curly
brackets, of course).

I need to an a simulated OR clause that also returns the invoice
number if Booking_method equals "Online Invoice". Where do I nest
the command?

Thanks in advance for your help!