[Doug Robbins - Word MVP]

What was the result?

Did you use Ctrl+F9 to insert each pair of field delimiters {}?

The formatting switch should be \@ "dd/MM/yyyy"

You may be able to fix the problem by selecting Options from the Tools menu
in Word and then go to the General tab and check the box against "Confirm
conversions at open" Then, when you attach the data source to the mail
merge main document, use the DDE option.

Alternatively, use the following field construction:

{ IF { MERGEFIELD contract_received } "12:00AM" { MERGEFIELD
contract_received
\@ "dd/MM/yyyy" } "" }

I am not sure that 12:00AM is exactly what is now being displayed when the
field is empty, so you should replace that what is actually being displayed.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"pama" wrote in message
...
Hello everyone,
I have the same problem as the post on 12/8/05 "Data fields in mail
merge",
so I will use their elequent words...
"I have a Word mail merge document, used to import Excel data - only
dates.
When I have merged the data, all empty Excel date cells are populated in
Word
by 12:00AM."
I then tried the fix for it.....
Use

{ IF { MERGEFIELD contract_received } "" { MERGEFIELD contract_received
\@"DD/MM/YYYY" } "" }

But this did not work.
Any suggestions?