General discussion

Locked

Format dates in Excel to Word Mail Merge

By gmulak ·
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?

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by DKlippert In reply to Format dates in Excel to ...

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"

Collapse -

by gmulak In reply to

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?

Collapse -

by DKlippert In reply to Format dates in Excel to ...

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.

Collapse -

by DKlippert In reply to

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

Collapse -

by gmulak In reply to

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

Collapse -

by gmulak In reply to Format dates in Excel to ...

This question was closed by the author

Back to Software Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums