IF MERGEFIELD is not working...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bart Paden - 13 Sep 2005 22:55 GMT

I am trying to use an if statement to put "and" between two fields as long
as the 2nd field is NOT BLANK. The first field is called firstname and the
second field is called secondname. Word recommends I use the following
code:

{ IF { MERGEFIELD secondname } <> "" "and" "" }

After manipulating it about 100 different ways and having it still not work
I'm completely frustrated. If there is anyone out there that has an idea of
what I am doing wrong I would really appreciate the assistance.

Thanks
B

Reply to this Message

Graham Mayor - 14 Sep 2005 04:59 GMT

Field boundaries {} are inserted with CTRL+F9. The construction you want is

{Mergefield firstname} {IF {Mergefield Secondname} <> "" "and {Mergefield
Secondname}"}

What you posted should also have worked if you inserted the fields
correctly.

Signature

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

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

> I am trying to use an if statement to put "and" between two fields as
> long as the 2nd field is NOT BLANK. The first field is called
[quoted text clipped - 10 lines]
> Thanks
> B

Reply to this Message

Bart Paden - 15 Sep 2005 17:05 GMT

Graham

Thanks for the help. With a couple tweaks your suggestion worked
brilliantly!

Bart

On 9/13/05 10:59 PM, in article #S9XQFOuFHA.2624@TK2MSFTNGP12.phx.gbl,

> Field boundaries {} are inserted with CTRL+F9. The construction you want is
>
[quoted text clipped - 3 lines]
> What you posted should also have worked if you inserted the fields
> correctly.

Reply to this Message

Rate this thread: