Solved

Word Mail Merge & DDE Commands

Posted on 2008-06-10
6
901 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
Comment Utility
.
0
 
LVL 19

Expert Comment

by:dlc110161
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Question PAQ'd, 300 points refunded, and stored in the solution database.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Introduction This tutorial provides instructions on how to properly format your Word document using the inbuilt tools provided. The benefits of using these tools means your documents are more accessible and easily portable to other applications an…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

771 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now