date format in mail merge

[dbatlmu]

We have upgraded from Word 2000 to Word 2002 SP3.
My mail merge documents have a merge field of a specific date obtained from
an Access MDB query - in W2000 this always printed out correctly.
However, although the Language is set to English UK in Word 2002, the date
always comes up in American format, i.e. 11/1/2005 instead of the English UK
1/11/2005.
I can find no way of amending this and thus the mail merge is useless to me
as I have to delete the merge field and type in the correct date format.
Any help to correct this would be apreciated as I have several mail-merge
documents affected by this glitch. Also, How do I get rid of the U.S English
option in Setting language to use in the document?
The Access database give the correct date format of medium date.

 

[macropod]

Hi dbatlmu,

the solution is as simple as adding a date 'picture switch' to your merge
field:
1. Select the field and press Shift-F9. You should see something like
{MERGEFIELD AccessDate}
2. Add a date 'picture switch' to the field so that it looks like any one
of:
{MERGEFIELD AccessDate \@ "dddd, d MMMM yyyy"}, or
{MERGEFIELD AccessDate \@ ", d MMMM yyyy"}, or
{MERGEFIELD AccessDate \@ "d MMM yyyy"}, or
{MERGEFIELD AccessDate \@ "dd/MMM/yyyy"}, or
{MERGEFIELD AccessDate \@ "d-MM-yy"}
etc
3. Press F9 to update the field
4. Run you mail merge.

Cheers

 

[dbatlmu]

Great - works just as I needed!
Many thanks