#1
|
|||
|
|||
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 _____________ |
#2
|
||||
|
||||
Try:
{={MERGEFIELD TaxExplorer_TaxCalc_SA302_CY_Bal_PMT} \# "$,0.00"} {={MERGEFIELD TaxExplorer_TaxCalc_SA302_NY_POA1} \# "$,0.00"} and {={={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] |
#3
|
||||
|
||||
Cross-posted at: http://www.excelforum.com/word-forma...ilmerging.html
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Loss of formulae values when mail merging excel to word | MellowMel | Mail Merge | 6 | 05-09-2014 09:08 AM |
Gaps in address mail merging | Trixz_D | Mail Merge | 2 | 08-05-2012 04:23 AM |
Word 2010 and Excel 2010 Mail merge - multiple headers | robby | Word | 3 | 04-18-2012 06:37 PM |
Mail Merging more than 1 line of data ?? | Keith24249 | Mail Merge | 0 | 10-16-2009 06:36 AM |
Mail merging and pulling varying data from Excel | shannag1881 | Mail Merge | 0 | 10-05-2009 08:51 AM |