DDE Connection for Mail Merge - Excel 2007

[sunday_storyteller]

I have mail merge document that I use all the time. It has many fields, and I don't want to put switches on all of them to maintain date, currence, time, etc formatting (unless I have to because there is no other way).

This document was written in Word 2003 and to pull from an Excel 2003 document. It worked fine for months.

I just had Office 2007 installed, and at first the document would not find the Excel document with the source fields. Now it has found it, but some fields are not corresponding and filling in at all. (I can fix this.) And the ones that are show up with the wrong formatting. For instance, a time is showing up as a decimal instead of a time.

When I first made the mail merge in 2003, I had to go back and switch the link type to "DDE", but I can't find where in Excel 2007 to make that switch. I've looked everywhere I think is remotely related to a mail merge. Has this functionality been removed? Or just well-hidden?

If anyone knows how to do this, please let me know.

Thanks!

Sunday_Storyteller

 

[UniMord]

Well hidden it is. This link on Graham Mayor's website will help you: http://www.gmayor.com/merge_labels_with_word_2007.htm