[Akron]

We're having the same exact problem. We selected the Word option to confirm
conversion and we even put our network directory as a trusted location. We
can't open the Excel file in the normal way that Word 2003 did. We have to
do one of two workarounds. Either put a copy of the Excel file on the
desktop and use that one to open in Word - or - open the Excel file FIRST,
then open the Word document and do the merge.


"JPal" wrote:

We have upgraded from Office 2003 to Office 2007.
Several WORD MailMerge documents that use EXCEL with DDE are not working
correctly after the change. Under 2003 we opened the Word document, it
opened the Excel data file, the dialog to connect the two was displayed and a
YES answer displayed the MailMerge document with the underlying data
displayed.

Under 2007, the connection between Word and Excel is established only if we
manually open the Excel file first. If the Excel file is not opened before
the Word mailmerge file then the connection process fails.

All files are on a network share and that network directory has been setup
as a Trusted Location in both Word and Excel. Not sure it matters but was
one of the things I tried attempting to resolve the problem.

Any suggestions would be appreciated.
JPal