[Steve]

I have exported data from Access into excel. I am trying to mail merge the
data into Word. One piece of data is the Date_of_Debt (which is a date).

My data connection works using Date_of_Debt. But when I look at the merged
data in word the date is showing as follows: 2005-08-02 00:00:00. No matter
how I format the date in excel (including using text format, general, and
different date formats) it still appears the same. I have also tried to
format the field in Word without success. Does anybody have any ideas?

Thx for the help in advance.