I am trying to create a mail merge document that will insert text
depending on the value on a certain field. For instance, Program is
the merge field and,

if Program = Live #1, insert "123456"
if Program = Live #2, insert "456789"
Otherwise, insert "987654"

I've tried inserting the following in the document where I want the
data above to be returned:

{IF {MERGEFIELD Program} = "Live #1" "For 123456" "{IF {MERGEFIELD
Program} = "Live #2" "456789" "987654"} "}

However, when I complete the merge, the text above is displayed, rather
than a corresponding value...am I putting this formula in the wrong
place? Any suggestions?

Thanks!

You have to use the special field braces that you can insert using ctrl-F9
for the {}. You can't just type them on the keyboard. You can type
everything else on the keyboard.

Peter Jamieson
"crun" wrote in message
ups.com...
I am trying to create a mail merge document that will insert text
depending on the value on a certain field. For instance, Program is
the merge field and,

if Program = Live #1, insert "123456"
if Program = Live #2, insert "456789"
Otherwise, insert "987654"

I've tried inserting the following in the document where I want the
data above to be returned:

{IF {MERGEFIELD Program} = "Live #1" "For 123456" "{IF {MERGEFIELD
Program} = "Live #2" "456789" "987654"} "}

However, when I complete the merge, the text above is displayed, rather
than a corresponding value...am I putting this formula in the wrong
place? Any suggestions?

Thanks!