#1
|
|||
|
|||
Multiple Merge Field in an "IF" Statement
When using an "IF" Statement in a Word Doc, is it possible to have the IF statement reference multiple Merge Fields?
The IF statement needs to check and see if there is a Date in the field "Rescission Date" field is SFDC, and if there is, the IF Statement then needs to check a different field, Called "State" and check for the State being CA. If there IS a Rescission Date, AND the State IS NOT CA, then print the paragraph, else leave the paragraph off the document. Basically, is this logic below correct? {IF {MERGEFIELD Opportunity_Rescission_Date \*MERGEFOREMAT} <> "" {IF {MERGEFIELD Opportunity_State \* MERGEFOREMAT} <> "CA" "Text" ""}} Cheers, Shawn |
#2
|
||||
|
||||
All you need is:
{IF{MERGEFIELD Opportunity_Rescission_Date}<> "" {IF{MERGEFIELD Opportunity_State}<> "CA" "Text"}}
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Multiple Merge Fields in an "IF" Statement
So my formula is correct?
|
#4
|
||||
|
||||
Not quite. Leaving aside the unnecessary (though not 'incorrect') use of the '\*MERGEFOREMAT' switches, inclusion of the final "" in your field construction was incorrect. You also had more spaces in the field construction than are absolutely necessary, but their inclusion is neither 'correct' nor 'incorrect'.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge Using Rules "IF" to add additional Text Based On Merge Field Content | Alfred | Mail Merge | 2 | 05-23-2017 10:59 PM |
Error: "Changes made were lost...reconnect with server", when switching "from" field | randhurrle | Outlook | 2 | 02-25-2015 06:51 PM |
Word options "field shading" reverts to "when selected" | PaulBurcham | Word | 1 | 04-20-2013 11:18 AM |
Applying "Paper Source" settings to multiple sections in a mail merge does not apply | ChrisC | Mail Merge | 1 | 06-18-2012 07:11 PM |
merge field formatting problem with "text to be inserted before" | wissam | Mail Merge | 0 | 12-13-2009 12:50 AM |