 |
 | 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 / March 2008The date in a merged word doc is US format source is UK format
I have created an access database with date fields in the UK format dd/mm/yyyy. When I merge this data into a word document the date field is shown in the US format mm/dd/yyyy. The regional settings are for the UK. Please advise a solution. Thank you Hi Cogito, You can fix this by adding a switch to the mergefield. To do this: . select the field and press Shift-F9. You should see something like {MERGEFIELD dbDate} . change this to {MERGEFIELD dbDate \@ DD/MM/YYYY} . press F9 to update the field . run your mailmerge For more information on field formatting, see Word's help file Cheers  Signaturemacropod [MVP - Microsoft Word] ------------------------- >I have created an access database with date fields in the UK format > dd/mm/yyyy. When I merge this data into a word document the date field is [quoted text clipped - 3 lines] > > Thank you Macropod Thank you for your reply. This solution worked. I am suprised that on a UK spec pc. Is there a permanent fix? Regards > Hi Cogito, > [quoted text clipped - 14 lines] > > > > Thank you That is the permanent fix. Word reads the raw data stored in Excel - See also From the Tools menu in Word, select Options and then go to the General tab and check the box against the "Confirm conversions at open" item. (In Word 2007 it is Office Button > Word Options > Advanced > General > Confirm file format conversion on open). Then when you attach the data source to the mail merge main document, you will be given the option of using the DDE method of connection which should read the data as you have it formatted in the table. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Macropod > [quoted text clipped - 27 lines] >>> >>> Thank you Graham Thank you for your reply. Excellent > That is the permanent fix. Word reads the raw data stored in Excel - See > also [quoted text clipped - 37 lines] > >>> > >>> Thank you
|
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.