I have three separate fields all merging information from an external source.

When the balance is 0.00 on the primary source it formats the amount in the report as a blank space.

I want to create an IF mailmerge that if the balance is 0.00 that it shows 0.00 instead of the blank space which it currently does.



The fundamentals of this calculation is that I want 1 + 2 = 3. The IF formula merge will be applied to "1."

1. { MERGEFIELD TaxExplorer_TaxCalc_SA302_CY_Bal_PMT }

2. { MERGEFIELD TaxExplorer_TaxCalc_SA302_NY_POA1 }

3. { = { MERGEFIELD TaxExplorer_TaxCalc_SA302_CY_Bal_PMT } + { MERGEFIELD TaxExplorer_TaxCalc_SA302_NY_POA1 }}

Any help would be grateful Thanks.

Simply add a numeric picture switch to your field code:

{={MERGEFIELD TaxExplorer_TaxCalc_SA302_CY_Bal_PMT}+{MERGEFIELD TaxExplorer_TaxCalc_SA302_NY_POA1} \# 0.00}

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks for the reply but my problem seems to lie with the merge field I labelled as "1." .. as this is the field that appears blank if no balance is due?

So it would be something to change the 'blank' outcome currently to output "0.00" ... of what I come to believe would be done via an IF statement?

noob to word and mail merging.

thanks

In that case, use:
{={MERGEFIELD TaxExplorer_TaxCalc_SA302_CY_Bal_PMT \# 0.00}+{MERGEFIELD TaxExplorer_TaxCalc_SA302_NY_POA1 \# 0.00} \# 0.00}

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]