Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-22-2017, 12:29 PM
JennEx JennEx is offline Odd Result In Combined Merged Time Fields Windows XP Odd Result In Combined Merged Time Fields Office 2013
Competent Performer
Odd Result In Combined Merged Time Fields
 
Join Date: May 2010
Posts: 162
JennEx is on a distinguished road
Default Odd Result In Combined Merged Time Fields

I am having great difficulty in displaying a mail merge field properly in the merged document. Time data is taken from two cells of an Excel data source. The final presentation combines the two dates into one field in a format to display like this for example: 10:00A - 10:30A. Instead, it comes messed up with a combination of characters I can't reproduce in this message other than by providing a picture.





This is the code I have in the field ...

{MERGEFIELD r1_srl \@"h:mmA/P"} - {MERGEFIELD r1_rsu \@"h:mmA/P"}
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Odd Result In Combined Merged Time Fields Adding sequential Number in a document that already has merged fields inserted Highlander01 Mail Merge 3 01-19-2016 12:33 PM
Time allotted minus time used with result in hour and minute esther6086 Excel 2 04-29-2014 05:03 PM
Formatting Merged Time Values Between Excel & Word JennEx Mail Merge 1 07-12-2012 02:54 PM
combined in-box for webmail accounts sonoman Outlook 1 07-19-2011 02:50 PM
word and excel combined jasperman Word 1 08-23-2010 06:49 AM

Other Forums: Access Forums

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