 |
 | 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 / January 2006Mail merge from Excel file changes date formatting
I have create a word document using an Excel worksheet as my database. The date format in the worksheet is dd/mm/yyyy but comes out as mm/dd/yyyy using the sql query function or yyyy/mm/dd if the data source is ODBC. How do I get the format I require with out making the 'date field' in the worksheet a text field?? Try this, Colin: http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm ************ Hope it helps! Anne Troy www.OfficeArticles.com >I have create a word document using an Excel worksheet as my database. The > date format in the worksheet is dd/mm/yyyy but comes out as mm/dd/yyyy [quoted text clipped - 4 lines] > text > field?? Thanks 1,000,000 Anne & Doug for the assistance - you saved me from going bald. > Try this, Colin: > http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm [quoted text clipped - 11 lines] > > text > > field?? You're welcome, Colin! ************ Hope it helps! Anne Troy www.OfficeArticles.com > Thanks 1,000,000 Anne & Doug for the assistance - you saved me from going > bald. [quoted text clipped - 17 lines] >> > text >> > field?? 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 >I have create a word document using an Excel worksheet as my database. The > date format in the worksheet is dd/mm/yyyy but comes out as mm/dd/yyyy [quoted text clipped - 4 lines] > text > field?? |
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.