Help With Time Formats When Doing A Mail Merge PLEASE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nylebella - 17 Mar 2005 20:23 GMT

Anyone who can help me I would appreciate it!
If I have an excel file or access database file that I am using as a
data source when doing a mail merge, how come the time format changes
in them? Example: I have a column of appointment times in the short
time format (5:00 PM) for example. It appears this way in both access
and excel. But when I merge that field into a documnet using Word mail
merge, the field ends up displaying as 5:00:00 PM - the "seconds"
indicator gets added in. Does anyone know how to fix this???
Thank you.

Reply to this Message

Greg - 17 Mar 2005 20:38 GMT

Try using a formatting switch

\@ "hh:mm 'PM'" in the mergefield

Reply to this Message

Georgina - 18 Mar 2005 03:56 GMT

I have a similar question: When merging DATES (eg. 23/12/05) from Access or
Excel to Word in a mail merge, it automatically changes it to US format and I
cannot find a way to keep it in the format I need.

> Try using a formatting switch
>
> \@ "hh:mm 'PM'" in the mergefield

Reply to this Message

Greg Maxey - 18 Mar 2005 04:09 GMT

Georgia,

Again I believe a switch should work. Something like:

{ MergeField "Your Mergefield Name" \@ "dd/MM/yy" }

You might also have a look at Graham Mayor's discussion on Word Fields here:
http://www.gmayor.com/formatting_word_fields.htm

Signature

Greg Maxey/Word MVP
A Peer in Peer to Peer Support
http://gregmaxey.mvps.org/word_tips.htm

> I have a similar question: When merging DATES (eg. 23/12/05) from
> Access or Excel to Word in a mail merge, it automatically changes it
[quoted text clipped - 3 lines]
>>
>> \@ "hh:mm 'PM'" in the mergefield

Reply to this Message

Rate this thread: