If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Mail Merge reverts excel date from ddmmyyyy to mmddyyy
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? |
#2
|
|||
|
|||
Mail Merge reverts excel date from ddmmyyyy to mmddyyy
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? |
#3
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|