Problems with fields containing dates

[Lenny of BOCES]

To all you professionals,

I am creating a mail merge in Word XP with an Excel XP
spreadsheet as my database. 3 fields contain dates as
it's data, but I am experiencing a problem. Whenever an
entry has one or more of these fields blank, the finished
merge inserts "12:00:00 AM" in the field instead of
leaving it blank. It does this with every single entry.

I have tried formatting the excel sheet itself, as well as
messing around with the MERGEFIELD switches, but to no
avail.

Please help me! This is for a client of mine. Even a
temporary fix would be very much appreciated.

Sincerely
Lenny of BOCES

 

[Lenny of BOCES]

Mr. Jamieson,

Thanks for your help. Your solution worked perfectly.
Now, I just have to figure out how to explain in to my
client.

Lenny of BOCES

 

[Peter Jamieson]

Maybe you could just send them a Word document with the fields in it and
explain Alt-F9 and that they need to put the right field name in.