Reply
 
Thread Tools Display Modes
  #1   Report Post  
nylebella
 
Posts: n/a
Default Help With Time Formats When Doing A Mail Merge PLEASE

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.

  #2   Report Post  
Greg
 
Posts: n/a
Default

Try using a formatting switch

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

  #3   Report Post  
Georgina
 
Posts: n/a
Default

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


  #4   Report Post  
Greg Maxey
 
Posts: n/a
Default

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



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Word 2003 Issue S.Nicks Mailmerge 5 February 20th 09 01:55 AM
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 15th 05 11:38 PM
time formatting and mail merge Lexisch Mailmerge 1 January 21st 05 01:29 AM
Word-Excel 2003 - Mail Merge Recipients problem AYager Mailmerge 2 January 11th 05 04:11 AM


All times are GMT +1. The time now is 03:03 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"