How to control Date format in Mailmerge export

[beginner33]

I am using Mailmerge to fill MS Word Documents with data from MS Access table. That works fine for years, but lately I have a problem with the format of one such field used for Date. It is always displayed in American way like “12/31/2011”, but I need “31.12.2011” style. Although the source data in MS Access table has a correct format: “31.12.2011” in MS Word the result always looks like “12/31/2011” no matter what you do. The problem appears when I start to use MS Office 2010. I noticed that this is not a problem in old MS Word documents that have been Mailmerge »connected« in my old Office 2000. The problem appears only, if I do the Mailmerge new from the scratch, with MS Office 2010. So far I couldn't find a way how to properly control, how the Date Mailmerge Field is displayed in MS Word. Nothing worked so far. I suspect that this is not necessary a bug in the MSOffice 2010, but there is probably only some setting or command in MS Word or MS Access, that I don't know.
This maybe look very minor problem to someone, but I literally need to produce hundreds of such documents in MS Word and correcting this Date format manually, needs a lot of effort… Does anyone has a knowhow, how to do it? Thanks in Advance!

[June7]

I remember another thread (can't find) with this very same issue. From what I can remember, there was no solution.

Try google: Access 2010 date format mail merge

[beginner33]

It really looks, that there is no such easy solution. I am thinking now about writing a VBA code for MS Word to change those date after mailmerge.

The problem now is how to find this "AnyMonth/AnyDay/2012" string and replace it with "AnyDay.AnyMonth.2012" string.

Can someone help me on this issue? Thanks!

[jongreen]

Add a switch to your format in the Word fieldcode
\@ "d MMMM yyyy"

[anamta]

Thanks. I'll try to figure out how to test for CR code, and then add code to change LF TO CR LF when no CR's are found.
_______________________
anamta