Mail Merging forumlas with Word 2010
I currently have my template to bring in figures from another software via mail merge and I am having trouble with a formula.
I posted previously about getting a mail merge of a blank figure to come through as 0.00.
Now I am having a problem with interlinking it into a different position in a table.. (see below, to my knowledge these fields I have attempted to code do work, please correct if you think otherwise)
What I am asking for help on is for the 'Balancing Payment due:' is to combine the two bolded merge fields, to have it into one merge formula? Which if one isn't correct, then to do the other, I am unsure how to do an OR formula on word? (hopefully it is possible)
Then I am sure it is as simple as just putting the new formula for Balancing payment due + Add: New Payment Due .. to get what I want?
If you need anymore details please ask, any help is appreciated!
_________________
Balancing Payment due:
{ IF "{ MERGEFIELD TaxExplorer_TaxCalc_SA302_CY_Bal_PMT }" <> "" "{ MERGEFIELD TaxExplorer_TaxCalc_SA302_CY_Bal_PMT }" "0.00" }
OR
{ IF { MERGEFIELD TaxExplorer_TaxCalc_SA302_CY_Bal_PMT } = "" "0.00" \* MERGEFORMAT \* MERGEFORMAT }
Add: New Payment due:
{ MERGEFIELD TaxExplorer_TaxCalc_SA302_NY_POA1 }
Total due: = two above added together
_____________
|