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.

Try using a formatting switch

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

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.

"Greg" wrote:

Try using a formatting switch

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

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 he
http://www.gmayor.com/formatting_word_fields.htm

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

Georgina wrote:
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.

"Greg" wrote:

Try using a formatting switch

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