Reply
 
Thread Tools Display Modes
  #1   Report Post  
cm53704
 
Posts: n/a
Default Word not connecting to Excel

Following message appears when trying to open the data source: Word could not
re-establish a DDE connection to Microsoft Excel to complete the current task.

Anyone know how to make the mail merge work even though this message is
occurring.

Thanks
  #2   Report Post  
Peter Jamieson
 
Posts: n/a
Default

If you can't get DDE to work you will have to use one of the other
connection methods - in Word 2000 and earlier, use the "Select method"
checkbox in the "Open Data Source" dialog box. In Word 2002 and later, check
Word Tools|Options|General|"Confirm conversion at open" then go through the
selection process again. IN both cases you should see an additional dialog
box prompting for the connection type, which could be
a. DDE
b. Converter (probably not in Word 2003)
c. ODBC
d. OLEDB (Word 2002/2003 only)

Choose anything except DDE and see if that makes a difference. Please note
that ODBC and OLEDB (at least) work with the underlying Excel data, not what
you actually see in Excel, so you will probably need to apply formatting in
Word to numeric and date values, e.g. change

{ MERGEFIELD mynumber }

to

{ MERGEFIELD mynumber \#0.00 }

There's more info about that in Word Help.

Peter Jamieson

"cm53704" wrote in message
...
Following message appears when trying to open the data source: Word could
not
re-establish a DDE connection to Microsoft Excel to complete the current
task.

Anyone know how to make the mail merge work even though this message is
occurring.

Thanks



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert Word 2003 documents to WordPerfect formate Carol Microsoft Word Help 6 March 9th 06 07:11 AM
creating forms Fluffypink Microsoft Word Help 4 March 9th 05 04:17 PM
Linking text from imbedded MS Word objects in Excel to an MS Word KG Microsoft Word Help 1 February 6th 05 04:10 AM
copying files from Wordperfect to Microsoft Word Juliet New Users 1 January 31st 05 05:41 PM
formatting links from excel into word (extra line feeds) JGT Microsoft Word Help 1 December 9th 04 11:01 AM


All times are GMT +1. The time now is 05:24 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"