mail merge and excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Laura - 09 Oct 2003 20:15 GMT

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?

Reply to this Message

Cindy M -WordMVP- - 11 Oct 2003 11:52 GMT

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
[quoted text clipped - 3 lines]
> saving the data then opening Word. Any clues on how to
> make it work the old way?

Cindy Meister

Signature

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

:-)

Reply to this Message