Display time in correct format in a mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mleisure - 18 May 2006 16:09 GMT

I'm creating a mail merge using an Excel worksheet as the source file and the
letter is in Word. One of the items in the worksheet is a date field
formatted as HH:MM AM(PM). When the data is merged, it displays as HH:MM:SS
AM(PM). How can I get the merge to display in HH:MM AM(PM) format?

Reply to this Message

Peter Jamieson - 18 May 2006 17:49 GMT

In your Word document, try Alt-F9 to reveal the field codes and modify, e.g.

{ MERGEFIELD mydatefield }

to look like

{ MERGEFIELD mydatefield \@"hh:mm am/pm" }

(If there are other "switches" such as \*Mergeformat, leave them)

Peter Jamieson

> I'm creating a mail merge using an Excel worksheet as the source file and
> the
> letter is in Word. One of the items in the worksheet is a date field
> formatted as HH:MM AM(PM). When the data is merged, it displays as
> HH:MM:SS
> AM(PM). How can I get the merge to display in HH:MM AM(PM) format?

Reply to this Message

MKLeisure - 18 May 2006 18:31 GMT

Thank you!

> In your Word document, try Alt-F9 to reveal the field codes and modify, e.g.
>
[quoted text clipped - 14 lines]
> > HH:MM:SS
> > AM(PM). How can I get the merge to display in HH:MM AM(PM) format?

Reply to this Message