DDE is at best flaky and not helped by running different versions of the
software. For this reason later versions have abandoned DDE as the default
connection method. Peter may be along later to offer his knowledge on the
subject but you could in the meantime try
From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. Then when
you attach the data source to the mail merge main document, you will be
given the option of using alternative methods of connection. See if one of
the alternatives works for you.
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
Len wrote:
I am working with 19 school districts and over 100 schools. Every
computer can have different Microsoft Word and Microsoft Access
installed.
I am getting the mesage:
Word could not re-establish a DDE Connection to Microsoft Access
When we get the funding we upgrade the oldest software and machines.
The system I am on now is SBS (Small Business Server) Word 2000 and
Access 2002.
As soon as I go to open the Access Database I get the error above.
This is happening on about 85% of my systems. What do I need to do
to get all of my Mail-Merges to work so that we can send the proper
letters to the proper paresnt?
I have been messing with this for several weeks and cannot find a
solution.
Thanks in Advance!
Len
I tried the solutions from previous postings and either I am
miss-understanding them or they do not work.