Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / December 2005

Tip: Looking for answers? Try searching our database.

Using Access 97 for Word 2000 Mailmerge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rich F - 21 Dec 2005 23:49 GMT
There are many threads that skirt arond my issue, but I wasn't able to find
an answer that appeared to circumvent my issue:

We are using Word 2000 and Access 97 on our machines at work.  Have a Word
document that mailmerges with an Access query that worked when all MS Office
apps were Office 97. When I try to open the document now (with Access 8976
and Word 2000), I get the messge that Word could not re-establish a DDE
connection to Microsoft Access to complete the current task.  I have attempte
to "find the data source" numerous times, but DDE is not an option when I'm
trying to reconnect (and that seems to be key to many other posters'
problems), so I've been unsuccessful at re-attacehing the Access query.  I
checked "Confirm conversion at Open," but still cannot find DDE as an option
when attempting to find the data source.  The Word file works fine on my
machine at home running Access 2003 and Word 2003.

Any guidance, o, sage ones?
Signature

Rich F

Cindy M  -WordMVP- - 25 Dec 2005 08:51 GMT
Hi =?Utf-8?B?UmljaCBG?=,

DDE is version-specific; you can't use DDE to connect Word 2000 to Access 97.

But you should be able to use ODBC, as long as the query in question is not a
parameter query, nor use user-defined functions (both require the Access UI in
order to execute).

> We are using Word 2000 and Access 97 on our machines at work.  Have a Word
> document that mailmerges with an Access query that worked when all MS Office
[quoted text clipped - 7 lines]
> when attempting to find the data source.  The Word file works fine on my
> machine at home running Access 2003 and Word 2003.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)
Rich F - 26 Dec 2005 15:54 GMT
Cindy,

That's sort of what I thought, but I was hoping there was a work around
someone might have known about.  Guess I'll just have to push for us to
upgrade to Access 2000, so it all works.

Thanks for the help and have a great new year!
Signature

Rich F

> Hi =?Utf-8?B?UmljaCBG?=,
>
[quoted text clipped - 23 lines]
> This reply is posted in the Newsgroup; please post any follow question or reply
> in the newsgroup and not by e-mail :-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.