Solved

Word Mail Merge & DDE Commands

Posted on 2008-06-10
6
931 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
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.

631 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