Solved

Word Mail Merge & DDE Commands

Posted on 2008-06-10
6
911 Views
Last Modified: 2009-05-06
I have a mail merge setup with my main document in Word 2000 and the data in an Excel 2000 spreadsheet.  I've had the same document merge setup on many computers for the past several years.  Suddenly, on one computer, when opening the main Word document, it hangs with "Waiting for Microsoft Excel to accept DDE commands".  I can open the Excel document by itself but not the Word document.  The only way I've able to fix this in the past by completely uninstalling and reinstalling Office.  No changes are made to the main document or the Excel data file.
Why does it suddenly stop working?  There must be an easier way to fix this than uninstalling and reinstalling Office, especially because all of the installations are are remote offices.
Any ideas on how to fix this?

Thanks,
Rich

0
Comment
Question by:RichJayBee
  • 2
  • 2
6 Comments
 

Author Comment

by:RichJayBee
ID: 21756476
.
0
 
LVL 19

Expert Comment

by:dlc110161
ID: 21761316
It sounds as though one of the DLL files are corrupting which are used in the Mail Merge. It should not be necessary to uninstall and reinstall. Instead, open Word or Excel and choose the Help menu, then choose the Detect and Repair option.

Dawn Crosier-Bleuel
Word MVP
0
 

Author Comment

by:RichJayBee
ID: 21762868
Dawn,
I tried the REPAIR option from Add/Remove Programs in the Control Panel, I was not aware of the Detect and Repair option in the Word Help menu.  Unfortunately, I've already uninstalled and reinstalled the program which has resolved the issue.  I will definitely try this the next time this comes up.
Thanks for your help!
Rich
0
 
LVL 19

Expert Comment

by:dlc110161
ID: 21774503
Hi Rich -

The detect and repair option is much less painful than uninstalling and re-installing. You may also want to change the Word settings so that you are prompted to identify the connection protocol when connecting to your Excel document. (Tools, Options, General - "Confirm Conversion at Open") Then you should recieve a prompt regarding whether to use DDE or OBDC to connect to Excel.

Hopefully that will solve your problem.

Dawn Crosier-Bleuel
Word MVP
0
 

Accepted Solution

by:
ee_auto earned 0 total points
ID: 24312209
Question PAQ'd, 300 points refunded, and stored in the solution database.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preface: When I started this series, I used the term CommandBars because that is the Office Object class that it discusses. Unfortunately, when Microsoft introduced Office 2007, they replaced the standard Commandbar menus with "The Ribbon" and rem…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial well show you how to find and replace special characters in Microsoft Word. This is similar to carriage returns to convert columns of values from Microsoft Excel into comma separated lists.

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question