Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 09-30-2015, 05:40 PM
macropod's Avatar
macropod macropod 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
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Try:
{IF{MERGEFIELD Household_Publish_Address_OK}= "True" "{MERGEFIELD Household_Address}, {MERGFIELD Household_Zip}"}
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



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 06:09 AM.


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