View Single Post
 
Old 05-17-2018, 05:17 PM
JennEx JennEx is offline Windows XP Office 2013
Competent Performer
 
Join Date: May 2010
Posts: 162
JennEx is on a distinguished road
Default Help Formatting Time in A MailMerge Field

I am having a difficult time formatting time in my mail merge document.

I have a column in my excel database database "starts". It contains a date value formatted as "h:mm AM/PM"

In my mailmerge document, I wish to use "starts" as a mail merge field to display time in the same format. I have used this:
{MERGEFIELD "STARTS" \@"h:mm AM/PM" }

But this just gives me decimals in my maile merged document.
Reply With Quote