View Single Post
 
Old 06-17-2013, 04:04 AM
aaiden aaiden is offline Windows XP Office 2010 32bit
Novice
 
Join Date: Jun 2013
Posts: 3
aaiden is on a distinguished road
Default 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

_____________
Reply With Quote