mail merge and excel

[Laura]

In previous version of Word when I opened a data source
that was Excel it automatically opened Excel and left
Excel open so that I could edit that new data. Now with
Word 2002 it doesn't open Excel and I'm not allowed to
add info without first opening Excel, editing the data,
saving the data then opening Word. Any clues on how to
make it work the old way?

 

[Cindy M -WordMVP-]

Hi Laura,

It's due to OLE DB being the new, default connection
method. You'll find information on how to change back to
DDE on my website, in the Word 2002 section of the mail
merge FAQ.

In previous version of Word when I opened a data source
that was Excel it automatically opened Excel and left
Excel open so that I could edit that new data. Now with
Word 2002 it doesn't open Excel and I'm not allowed to
add info without first opening Excel, editing the data,
saving the data then opening Word. Any clues on how to
make it work the old way?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail