Mail Merge with MS Word produces incorrect date format

[parko]

Hi can anyone help?

I want to use the Mail Merge with MS Word feature to give me the option to produce a Word document based on a recordset in an Access DB.

I've managed to successfully merge the word doc to a table of records in my database but fields with a date/time data type come out in USA format i.e. mm/dd/yyyy in the word doc.

However my date/time settings are in dd/mm/yyyy format and in my Access table they are ok. Can anyone think what may be the problem.

Dave

 

[richary]

You probably need to change the format of the merge field in Word. Do a search in Word for "format merged data".

 

[b_karv]

Yeah I had the same problem.....

Basically in Access makesure the format of the dates are in medium format. Then in word right click the merge field then click on toggle field codes. For example if you have a field called dates it would like:

{MERGEFIELD "dates" }

Pretty much then type the following after the merge item \@ "d MMMM, yyyy"

That is in this case
{MERGEFIELD "dates" \@ "d MMMM, yyyy" }

Formats should be right now

Also forgot to mention if the problem still exists, makesure you have the latest update of office & Access

good luck!!