View Single Post
  #3  
Old May 24th, 2010, 06:53 AM posted to microsoft.public.word.mailmerge.fields
Bill
external usenet poster
 
Posts: 1,009
Default Mail Merge reverts excel date from ddmmyyyy to mmddyyy

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?