This is often an indication of an empty field - From the Tools menu in Word,
select Options and then go to the General tab and check the box against the
"Confirm conversions at open" item. Then when you attach the data source to
the mail merge main document, you will be given the option of using the DDE
method of connection which should read the data as you have it formatted in
the table.
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
riri wrote:
Hello,
I m merging some data in an excel sheet that in some fields I m
getting 12:00:00 AM instead of a date I have tried everything but
nothing seems to be working. Can anyone help out?
Thanks in advance