Compound "IF" formatting issue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J_Piazza - 20 Sep 2006 14:43 GMT

Could someone please tell me what I am doing wrong with formatting the "IF"
test below. I have compared it repeatedly to examples on the Web. When I
toggle out of the field code view, instead of disappearing I see a shaded
"{". The validator finds no errors.

{IF { = AND ( { COMPARE { MERGEFIELD Hope_Fund_Flag } = "Y"}, { COMPARE {
MERGEFIELD ABC_Flag } = "Y" } ) } = 1 "{ INCLUDETEXT "C:\\Documents and
Settings\\piazzaj.000\\Desktop\\Mail Merge Merge\\Hope Fund Status.doc"
Hope_Anu}" ""}

Thank you

Reply to this Message

Graham Mayor - 20 Sep 2006 15:35 GMT

It works here - my guess is that you have not used CTRL+F9 for each pair of
field boundaries. In particular, what is the orphan Hope_Anu bit all about?
Something along the lines of

{ INCLUDETEXT { IF{ =AND ({ COMPARE{ MERGEFIELD Hope_Fund_Flag \*upper} =
"Y" },{ COMPARE{ MERGEFIELD ABC_Flag \*upper} = "Y" }) }= 1
"C:\\Documents and Settings\\piazzaj.000\\Desktop\\Mail Merge Merge\\Hope
Fund Status.doc" "C:\\Documents and Settings\\piazzaj.000\\Desktop\\Mail
Merge Merge\\Blank.doc"} }

should prove more reliable. In this instance you will have to create a blank
document for the Nul condition or you will get an error message.

Signature

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

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

> Could someone please tell me what I am doing wrong with formatting
> the "IF" test below. I have compared it repeatedly to examples on the
[quoted text clipped - 7 lines]
>
> Thank you

Reply to this Message

Peter Jamieson - 20 Sep 2006 16:00 GMT

It looks OK here too, and I agree with your analysis. There is one other
possible though unlikely explanation:

> In particular, what is the orphan Hope_Anu bit all about?

I assume it is intended to be the name of a bookmark in the included
document. If the included document happens to contain a "{" character and
that is the only character that has been bookmarked (probably wrongly) as
"Hope_Anu", then the result would be as described.

Peter Jamieson

> It works here - my guess is that you have not used CTRL+F9 for each pair
> of field boundaries. In particular, what is the orphan Hope_Anu bit all
[quoted text clipped - 19 lines]
>>
>> Thank you

Reply to this Message

J_Piazza - 20 Sep 2006 16:06 GMT

Thank you ... that solved the problem. I started with CTL + F9, I just didn't
realize I needed to do it for each section.

> Could someone please tell me what I am doing wrong with formatting the "IF"
> test below. I have compared it repeatedly to examples on the Web. When I
[quoted text clipped - 7 lines]
>
> Thank you

Reply to this Message