Waiting for Excel to accept DDE command mail merge

  CLONNEN 17:39 10 Mar 09
Locked

Whenever I try to open a Word document that contains mail merge fields linked to an Excel spreadsheet I get the following message at the bottom of the Word document :

Waiting for Microsoft Excel to accept DDE commands

It just stays like that until I click somewhere then it says in the titlebar Not Responding.

This has been happening ever since I upgraded to Service Pack 3 on my XP system.

Is there a way of fixing this so that I can mail merge again or do I need to uninstall SP3 and go back to SP2?

I'm using Microsoft Office 97 by the way.

  VoG II 17:49 10 Mar 09

Is Ignore other applications ticked in Excel Tools > Options > General?

  CLONNEN 18:12 10 Mar 09

No "Ignore other applications" box is not ticked

  CLONNEN 07:01 11 Mar 09

click here

The link above says SP3 definitely changes something to do with DDE

  CLONNEN 07:28 11 Mar 09

Well can't get DDE to work using their instructions but ODBC seems to work alright.

Changed the name of Excel spreadsheet so it cannot try to link to it.

Opened the Word document - it says cannot find data source - click Find Data Source button

Tick the box for Select Method on the right

Navigate to Excel spreadsheet and select it and click Open

Then it gives you a choice of DDE or ODBC - choose the ODBC option

Then select the table you want as the data source - in mine there is only one - click OK

Click Mail Merge Helper button on toolbar

Then just Mail Merge as usual (re-setup any Query Options).

  CLONNEN 19:31 11 Mar 09

Here is a handy list of formatting codes for mail merging with OLE and ODBC. Useful for date and number formats.

click here

This thread is now locked and can not be replied to.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…