Dates issues with mail merge Access to Word

[Van T. Dinh]

The safe way to do MailMerge with dates is to use the
Format() function in Calculated Fields in a Query and use
the Query as the datasource for MailMerge. Since the
Format function converts the date value to Text, Word
won't try to convert your Text value to anything strange.

For example, in your Query, instead of your date field,
use:

DateText: Format([YourDate], "dd/MMM/yyyy")

HTH
Van T. Dinh
MVP (Access)