I'm trying to merge a document with a data source from
Excel but the result I get is always the first
percentage field repeated for all statements
regardless of the condition. It ignores the rest of
the nested if_statement.

{ IF {MERGEFIELD PledgeCode} = €œ05 Foundation€� €œ5%€� €œ{
IF {MERGEFIELD PledgeCode} = €œ05 Builders€� €œ7%€�{ IF
{MERGEFIELD PledgeCode} = €œ05 Encouragers€� €œ10%€�{ IF
{MERGEFIELD PledgeCode} = €œ05 Restorers€�€�15%€�{ IF
{MERGEFIELD PledgeCode} = €œ05 Sustainers€� €œ20%€� €œ€� }€�
}€� }€� }€�

This outputs 5% regardless of the PledgeCode

Vera

I believe Word gets confused because the first part of the code is a number,
and that if you change each

{ MERGEFIELD PledgeCode }

to

"{ MERGEFIELD PledgeCode }"

the IF statement will work properly.

Peter Jamieson

"vobonyo" wrote in message
...
I'm trying to merge a document with a data source from
Excel but the result I get is always the first
percentage field repeated for all statements
regardless of the condition. It ignores the rest of
the nested if_statement.

{ IF {MERGEFIELD PledgeCode} = "05 Foundation" "5%" "{
IF {MERGEFIELD PledgeCode} = "05 Builders" "7%"{ IF
{MERGEFIELD PledgeCode} = "05 Encouragers" "10%"{ IF
{MERGEFIELD PledgeCode} = "05 Restorers""15%"{ IF
{MERGEFIELD PledgeCode} = "05 Sustainers" "20%" "" }"
}" }" }"

This outputs 5% regardless of the PledgeCode

Vera

Thanks. It works wonderfully now.

Vera

"Peter Jamieson" wrote:

I believe Word gets confused because the first part of the code is a number,
and that if you change each

{ MERGEFIELD PledgeCode }

to

"{ MERGEFIELD PledgeCode }"

the IF statement will work properly.

Peter Jamieson

"vobonyo" wrote in message
...
I'm trying to merge a document with a data source from
Excel but the result I get is always the first
percentage field repeated for all statements
regardless of the condition. It ignores the rest of
the nested if_statement.

{ IF {MERGEFIELD PledgeCode} = "05 Foundation" "5%" "{
IF {MERGEFIELD PledgeCode} = "05 Builders" "7%"{ IF
{MERGEFIELD PledgeCode} = "05 Encouragers" "10%"{ IF
{MERGEFIELD PledgeCode} = "05 Restorers""15%"{ IF
{MERGEFIELD PledgeCode} = "05 Sustainers" "20%" "" }"
}" }" }"

This outputs 5% regardless of the PledgeCode

Vera