Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge in Word XP using Access XP as the data source
We're trying to merge dates that appears ok as dd/mm/yyyy format in Access to
a Word XP document. Looks ok, until you look at the merged data which automatically appears as mm/dd/yyyy! It's driving us batty! Has anyone out there got a 'fix' for this problem? We've looked at global date settings etc. but whatever we do, the end result is still showing us the mm/dd/yyyy format. Thanks. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge in Word XP using Access XP as the data source
If using a date switch in Word does not work, i.e.
{ MERGEFIELD mydate \@"DD/MM/YYYY" } then it's down to a known problem with OLE DB. Be careful as using the date switch may show unambiguous dates correctly (e.g. where the day is 17, it cannot be misinterpreted as a month) but still switch the day and month e.g. for 6/9/2007 or 9/6/2007. In earlier versions of Word 2002, there was a hotfix for this problem. However, if you have the up-to-date SP3 version, your MDAC (data access stuff) is up-to-date and you are still seeing it, then I suspect the problem has never been permanently fixed and that you will need to use another approach, e.g. a. connect using DDE (check Word-Tools-Options-COnfirm conversions at open, go through the connection process again, and select the DDE option when offered. But you need Access on the machine for that, and the interaction is more complex. b. write a query in Access that returns the date in YYYY-MM-DD format, then use that query as the data source and a DD/MM/YYYY switch (as above) in your Mailmerge fields. -- Peter Jamieson http://tips.pjmsn.me.uk "Steve" wrote in message ... We're trying to merge dates that appears ok as dd/mm/yyyy format in Access to a Word XP document. Looks ok, until you look at the merged data which automatically appears as mm/dd/yyyy! It's driving us batty! Has anyone out there got a 'fix' for this problem? We've looked at global date settings etc. but whatever we do, the end result is still showing us the mm/dd/yyyy format. Thanks. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error in Mail Merge with MS Access - can't find data source | Mailmerge | |||
Word 2000 mail merge documents won't save Access 2000 data source | Mailmerge | |||
Using Access as mail merge data source | Mailmerge | |||
Unable to use Access queries as data source for a mail merge doc | Mailmerge | |||
How can I fix the Access data source of the mail merge for Word | Mailmerge |