[bill]

I export files from access to excel and then use them do do a mail merge in
word.

The excel files use the ddmmyyyy format.

As soon as I select the file in word it converts the file date and all
internal dates to mmddyyyy.

How do I stop this?

[Doug Robbins - Word MVP]

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002/2003" 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, originally posted via msnews.microsoft.com

"Bill" wrote in message
...
I export files from access to excel and then use them do do a mail merge
in
word.

The excel files use the ddmmyyyy format.

As soon as I select the file in word it converts the file date and all
internal dates to mmddyyyy.

How do I stop this?

[bill]

Thanks Doug - answered the question perfectly

"Doug Robbins - Word MVP" wrote:

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002/2003" 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, originally posted via msnews.microsoft.com

"Bill" wrote in message
...
I export files from access to excel and then use them do do a mail merge
in
word.

The excel files use the ddmmyyyy format.

As soon as I select the file in word it converts the file date and all
internal dates to mmddyyyy.

How do I stop this?