View Single Post
 
Old 04-22-2017, 12:29 PM
JennEx JennEx is offline Windows XP Office 2013
Competent Performer
 
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