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
by gmulak
This discussion is closed to new replies.
Trending Software posts
Sort by Trending