Mail Merge a Date from Excel to Word

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Field w/Date 1
Mail Merge Question with Excel 4
Mail merge date format 1
Mail merge between Word and Excel 1
Problems with Mail Merge and Dates 3
Date Format needs to change from Mail Merge 1
Word Mail Merge Formatting Issue Font Size 0
Formatting a Merge field from xls doc 4

Top