J
Jenn68
I cannot understand why certain fields within my mailmerge document ar
not displaying the proper formats despite my switches.
My datasource is an Excel worksheet.
I have time fields, that are displaying in their decimal equivalent
rater than the "h:mm AM/PM" format coded.
{MERGEFIELD "Start" \@ "h:mm am/pm"}
The data in excel is a time value formatted as "h:mm AM/PM".
I have one date field displaying it's serial value rather than the "
-MMM" format coded.
{MERGEFIELD "close_date" \@ "d-MMM"}
The data in Excel, a number, is 41477, and this is how it's displayin
in the mailmerge document. Should be 22-Jul
not displaying the proper formats despite my switches.
My datasource is an Excel worksheet.
I have time fields, that are displaying in their decimal equivalent
rater than the "h:mm AM/PM" format coded.
{MERGEFIELD "Start" \@ "h:mm am/pm"}
The data in excel is a time value formatted as "h:mm AM/PM".
I have one date field displaying it's serial value rather than the "
-MMM" format coded.
{MERGEFIELD "close_date" \@ "d-MMM"}
The data in Excel, a number, is 41477, and this is how it's displayin
in the mailmerge document. Should be 22-Jul