Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-30-2015, 05:13 PM
SoonerLater SoonerLater is offline Use Two (concatenate) Fields If Condition Is Met (If... Then... Else) Windows 7 64bit Use Two (concatenate) Fields If Condition Is Met (If... Then... Else) Office 2010 32bit
Novice
Use Two (concatenate) Fields If Condition Is Met (If... Then... Else)
 
Join Date: Sep 2015
Posts: 3
SoonerLater is on a distinguished road
Default Use Two (concatenate) Fields If Condition Is Met (If... Then... Else)

I am having trouble with an IF... THEN... ELSE situation. I need that if the IF condition is met, that I can insert two mergefields. Or to put it another way, I need the IF found result to insert a concatenated result.

In this example:

Code:
{If {MERGEFIELD "Household_Publish_Address_OK"} = "True" {MERGEFIELD "Household_Address}+", "+{MERGFIELD}"Household_Zip"}}
when the IF condition is TRUE, I only get the contents of {MERGEFIELD "Household_Publish_Address_OK"}. I never get the rest of what I want, which is ", "+{MERGFIELD}"Household_Zip"}.

I've googled and searched for concatenate and concatenation in the Word mail merge environment, but can't find anything relevant.
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to concatenate text box on new slide wichitawx PowerPoint 5 05-19-2015 05:17 AM
Use Two (concatenate) Fields If Condition Is Met (If... Then... Else) Concatenate with @ symbol anickles Excel 2 02-06-2015 09:39 AM
Use Two (concatenate) Fields If Condition Is Met (If... Then... Else) Concatenate if in descending order pgeorgilas Excel Programming 2 12-10-2014 01:35 AM
Concatenate two textbox values for message box Smithy02468 Excel Programming 1 11-08-2014 10:48 PM
If, move and concatenate in VBA devcon Excel Programming 0 07-04-2011 12:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:39 AM.


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