[Graham Mayor]

You are welcome

--

Graham Mayor - Word MVP

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


kojaks43 wrote:
Thanks, Mr Mayor:
This was hard as it was the first time I tried the mergefield
business. It took me a few tries to understand I needed to do Ctrl
F9 for each set of braces. I did it once and then typed subsequent
braces. When it dawned on me I was getting a non-bold brace and
curley quotes, I realized my error. It works fine for me now.
Again thanks for the guidance and patience.
k

"Graham Mayor" wrote:

That is not what I advocated!

If you toggle the display (ALT+F9)

you want

{Mergefield Prefix} {Mergefield First_Name} {Mergefield Last_Name}
{Mergefield Provider}
{Mergefield Address1}{IF {Mergefield Address2} "" "
{Mergefield Address2}"}
{Mergefield City}, {Mergefield State} {Mergefield Zip}

which would be the equivalent of

«Prefix» «First_Name» «Last_Name»
«Provider»
«Address1» {IF «Address2» "" "
«Address2»"}
«City», «State» «Zip»

Pairs of field brackets are each inserted with CTRL+F9
You can insert the mergefields from the toolbar or better still
enter them manually.
When you have finished, toggle the display again (ALT+F9)

--

Graham Mayor - Word MVP

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



kojaks43 wrote:
This is what I did: ( inserted the data fields from my Excel file, I
then added the IF statement and this is what it looked like:

«Prefix» «First_Name» «Last_Name»
«Provider»
«Address1»
{IF (MERGEFIELD Address2 ""}«Address2»
«City», «State» «Zip»

This was the result:
Ms. Paula Funez
Baptist Echocardiography
P.O. Box 970252
{IF (MERGEFIELD Address2 ""}(blank)
Miami, FL 33197
As you can see, it not only continues to print (Blank) now it
includes the IF statement.

I think this could give me another heart attack!

What have I done wrong here?

"Graham Mayor" wrote:

The simplest approach which works for all versions is to use a
conditional field to insert the field only when it has content ie

{Mergefield Address1}{If{Mergefield Address2} "" "
{Mergefield Address2}


--

Graham Mayor - Word MVP

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