Date format in mail merge

[Peter Glennon]

When I use mail merge to create a Word document from an
Access 2000 database I am always getting the US date
format, even though I have UK English as my computer
default, UK date format in my Access database and have
tried every kind of format switch at the Word end.

The problem seems to be with the ODBC link. If I use a
DDE link with an Access 97 database the date format is
OK. I can't create a DDE link with Access 2000.

Any solutions please?