Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-08-2016, 03:36 PM
JennEx JennEx is offline Mergefield Consisting of Concatenated Strings Windows XP Mergefield Consisting of Concatenated Strings Office 2013
Competent Performer
Mergefield Consisting of Concatenated Strings
 
Join Date: May 2010
Posts: 162
JennEx is on a distinguished road
Default Mergefield Consisting of Concatenated Strings

I'm working on a complex rule for a mail merge field ...

If mail merge field 'r1_relchg' is blank (="") then display "", otherwise display 'r1_sru' (h:mmA/P) - 'r1_srl' (h:mmA/P)



An example of the presentation if r1_relchg <> "" might be:

9:00A-9:30P

I am not certain how, if its possible, to concatenate the 'r1_sru', '-'. and 'r1_srl'
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mergefield Consisting of Concatenated Strings Printing selected pages based on a MERGEFIELD.g. If MERGEFIELD=x then print pages 1,2,4 if MERGEFIEL Richard.p Word 3 04-21-2015 01:14 AM
Save merged document as concatenated merge field values texas791 Word VBA 4 02-25-2014 07:35 PM
Mergefield Consisting of Concatenated Strings Search with multiple strings silverspr Excel 7 03-03-2013 04:45 PM
Concatenated data in subsequent rows doorsgirl Excel 4 09-15-2011 10:37 PM
Mergefield Consisting of Concatenated Strings update style of all strings available between two specific strings vikrantkale Word 1 03-28-2011 06:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:42 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