Discussion Locked

Format dates in Excel to Word Mail Merge

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have the need to make a calendar and want to merge the dates to a MS Word document I have created. I have put the dates in Excel in the format 01/01/2004, 01/02/2004, 01/03/2004.... and concantenated them for the whole year in Excel. I then used the Format>Cells>Date menu to format it as Thursday, January 1, 2004. However, when I transfer it to Word in Mail Merge is will only transfer the date 01/01/2004. How can I change the formating?

6 replies

by dklippert

If you are using 2002+, use DDE in Mailmerge, not ODBC.
This appears to have been broken from previous versions.
Another way to do it is to add the picture flag:
\@"dddd,MMMM dd, yyyy"

by gmulak

The answer really got me thinking and it is so appreciated. But I do not know how to implement Dynamic Data Exchange or how it would help me in this situation. Dynamic data linkin in a document is for when you make a change in one document it automatically changes in another. How is that going to help me in this situation and how do I implement it?

by dklippert

If you are using Word 2002 and above, when you attach the data file, you are asked how you want to import the data. ODBC is the "default" selection, but it doesn't carry the formatting.
Before 2002 the transfer mechanism was DDE. Use that.
Try disconnecting the data source and then bring it back.

by dklippert

Tools>Options>General "Confirm conversions at open"
I think the new one might be called OLEDB, but I find DDE works best.

by gmulak

Thank you, I found it when I went to get data source in Word 2000, there is a little box that says "select method" which I checked and THEN it allowed me to select DDE. I then formated the dates in the format I wanted and merged them over. It worked, thank you very very much. I like how you don't give all the answer, but just enough to figure it out, it helps me learn by doing it myself. God bless, George

This discussion is closed to new replies.