See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at
http://homepage.swissonline.ch/cindy...r/MergFram.htm


--
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
"Andy Davis" wrote in message
...
I have a table of data in Access 2002 which is used as the source table for
a mail merge document using Word 2002 on my clients PC. The data is
transferred OK but I've noticed that any dates which fall between
1stday/anymonth/any year and 12thday/anymonth/any year are rearranged in
the
wrong format. For example 4th July 2005 from the database would be
displayed
as 07/05/2005 in the merged document. In addition blank date fields from
the
source table are shown as the current date for that particular day. This
strange anomaly does not occur for any dates where the day goes beyond
12!?

However, when I run the same document and source on my own PC using Word
2003 the dates in the merged document are shown correctly and in the
correct
format and blank date data is not shown. As a stab in the dark I'm using
Microsoft Word 11.0 Object library as the reference setting. Should this
be
changed for Word 2002 to a lower reference? Or could there be a bug in
Word
2002?

Any help or feedback would be much appreciated. At present my client would
have to check the document for all those dates 12th/month and edit them.
Obviously not very efficient.

Many thanks in advance