 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / June 2005Bug in Word 2003 (mail merge & date format)?
Hello all. Just had a really weird situation. I have Office 2003 (portuguese) installed. I imported an Excel 2003 file into access 97, then merged the resulting table into a Word 2003 new doc. This table had a date field formated for DD/MM/YYYY. When I merged, Word changed to the field to MM/DD/YYYY and I couldn't find a way to undo this. I then tried to merge from the original Excel 2003 file: same result. The only solution I could find was to change the data field format from "date" to "text" and re-merge... I checked the PC's regional settings and they are ok. As anyone had this problem? Try this, Joao: http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm ******************* ~Anne Troy > Hello all. > [quoted text clipped - 9 lines] > I checked the PC's regional settings and they are ok. > As anyone had this problem? !!!!! Hell... So, we now have more work to do than in the old, 97, version? Jeez... Thanks for the info, anyway. I'll compare your solution and mine and see which is less of a hassle ;) Cheers > Try this, Joao: > http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm > ******************* I don't know what it at the site to which Anne directed you because it does not appear to be available at the moment, but 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/cindymeister/MergFram.htm  SignatureHope 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 > !!!!! Hell... > [quoted text clipped - 8 lines] >> http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm >> ******************* |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.