Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-24-2020, 02:50 PM
shawn.low@cox.net shawn.low@cox.net is offline Multiple Merge Field in an "IF" Statement Windows 10 Multiple Merge Field in an "IF" Statement Office 2016
Novice
Multiple Merge Field in an "IF" Statement
 
Join Date: May 2019
Location: Aliso Viejo, CA.
Posts: 24
shawn.low@cox.net is on a distinguished road
Default 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
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Merge Field in an &quot;IF&quot; Statement 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
Multiple Merge Field in an &quot;IF&quot; Statement Word options "field shading" reverts to "when selected" PaulBurcham Word 1 04-20-2013 11:18 AM
Multiple Merge Field in an &quot;IF&quot; Statement 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft