View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor
 
Posts: n/a
Default OR in a mergefield?

There is an alternative method for testing for a value in fields shown at
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Peter Jamieson wrote:
There is no OR in the IF field, but there are other ways to achieve
the same effect, depending on exactly what you need.

{ IF "{ MERGEFIELD Company }" = "Company A" "X" "Y" }
{ IF "{ MERGEFIELD Company }" = "Company B" "X" "Y" }

is one way that may be enough in simple situations.

{ COMPARE "{ MERGEFIELD Company }" = "Company A" } returns 1 if
Company is "Company A", 0 otherwise, so you can use

{ IF { =or({ COMPARE "{ MERGEFIELD Company }" = "Company A" },{
COMPARE "{ MERGEFIELD Company }" = "Company B" }) } = 1 "X" "Y" }

or just use addition, e.g.

{ IF { ={ COMPARE "{ MERGEFIELD Company }" = "Company A" }+{ COMPARE
"{ MERGEFIELD Company }" = "Company B" } } 0 "X" "Y" }

Peter Jamieson
"Compass Rose" wrote in
message ...
I would like to use OR in an If...then...else... Word Field.

If {MERGEFIELD Company} = "Company A" OR {MERGEFIELD Company} =
"Company B"
OR {MERGEFIELD Company} = "Company C" then......

Is it possible, and if so, what is the correct syntax?

TIA
David