Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Word Mail Merge & DDE Commands

Posted on 2008-06-10
6
Medium Priority
?
952 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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!
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

886 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