 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / May 2004DDE, microsoft-ds
(W2K, Office 2000, updates, service packs installed) Following some security advice I disabled microsoft-ds. But then MS-Word hangs if I open a (specific) mailmerge-Document which gets data from an excel-sheet. "WORD is waiting for Excel to accept DDE commands". (I think I could open another document which uses the same sheet but different data. Then I reactivated microsoft-ds and now the DDE is working again Is that obvious to anybody? Is there a reference that could illuminate me Oskar Just guessing, but with W2K, DDE may just be a "special case" of NetDDE, which AFAIK does rely on Active Directory. If you are in a position to change this merge application, if you can't use DDE, from Word 2000 you can try connecting to Excel using ODBC or the Excel Converter - but you will probably have to deal with numerous differences in behaviour, especially the formatting of dates, numbers, percentages and things that ODBC (say) thinks are numeric. You can generally get around most of these by formatting your columns in Excel appropriately and using format switches (\# and \@) in the MERGEFIELD fields in your Word mail merge main document.  SignaturePeter Jamieson > (W2K, Office 2000, updates, service packs installed): > Following some security advice I disabled microsoft-ds. But then MS-Word hangs if I open a (specific) mailmerge-Document which gets data from an excel-sheet. "WORD is waiting for Excel to accept DDE commands". (I think I could open another document which uses the same sheet but different data.) > Then I reactivated microsoft-ds and now the DDE is working again. > > Is that obvious to anybody? Is there a reference that could illuminate me? > > Oskar One problem was that I couldn't open the document with DDE not working because Word "hangs" (or was 15 minutes waiting not enough?). Therefore I couldn't change the interface. :- Oskar Try creating a blank new document and inserting the existing document into it. You may lose some stuff, including any sort/filter settings, but you should retain the merge fields etc. SignaturePeter Jamieson > One problem was that I couldn't open the document with DDE not working because Word "hangs" (or was 15 minutes waiting not enough?). Therefore I couldn't change the interface. :-( > Oskar I'm encountering this same problem of DDE not working when I try to get the data source (either Excel or Access) to merge with a Word document. I'm using Office 2000 Prof and Windows XP. Can anyone help, please? >-----Original Message----- >One problem was that I couldn't open the document with DDE not working because Word "hangs" (or was 15 minutes waiting not enough?). Therefore I couldn't change the interface. :-( >Oskar >. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.