Word 2002 mail merge needs to show time in hh:mm format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DevilDogzMom@Iloveaol.com - 17 Aug 2005 06:06 GMT

I am using Word 2002 as part of MS Works Suite with a Works database as the
mailmerge data source. When I merge my time fields Words uses the format
"h:m:s" unless the number is 2 digits (ie. 11:05PM shows as 11:5:0PM) At the
very least I need the leading zero in the minutes field. Tried to figure out
how to "force" the formatting of time to no avail. The formatting of the
source database does not carry over..... I have tried all things including
miliatary time. HELP!
Thanks!
deb

Reply to this Message

Doug Robbins - 17 Aug 2005 08:08 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am using Word 2002 as part of MS Works Suite with a Works database as the
> mailmerge data source. When I merge my time fields Words uses the format
[quoted text clipped - 7 lines]
> Thanks!
> deb

Reply to this Message

Graham Mayor - 17 Aug 2005 10:55 GMT

Specifically for this one the switch is {Mergefield DATEFIELD \@ "h:mm
am/pm" }

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> See "Formatting Word fields with switches" on fellow MVP Graham
> Mayor's website at
[quoted text clipped - 13 lines]
>> Thanks!
>> deb

Reply to this Message