View Single Post
  #2   Report Post  
Graham Mayor
 
Posts: n/a
Default

You can apply the correct formatting with a switch - see
http://www.gmayor.com/formatting_word_fields.htm or you can use a different
method of connecting to your data - see the Excel data section of
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm

--

Graham Mayor - Word MVP

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




Thang wrote:
Hello,

I had a date formatting problem when using mail merge in
Word 2003.
My data source is an Excel worksheet, when I inser merge
field in my letter, if the data is a date/time I get the
mm/dd/yyyy format instead of dd mmm yy format as in the
Excel worksheet.
Some time, I get also a serial date number as 38494 in my
letter instead of 22 May 05.

I've never got this problem using Word 97!

Many thanks for your help.

Thang