Waiting for Excel to accept DDE command mail merge

  CLONNEN 17:39 10 Mar 2009

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 2009

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

  CLONNEN 18:12 10 Mar 2009

No "Ignore other applications" box is not ticked

  CLONNEN 07:01 11 Mar 2009

click here

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

  CLONNEN 07:28 11 Mar 2009

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 2009

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.

Elsewhere on IDG sites

Best Amazon Echo: What’s the best Alexa speaker?

Kano Computer Kit Complete review: A fun DIY 'laptop' that teaches kids to code

Best pro photo editors for Mac 2018

TV & streaming : comment regarder les Jeux olympiques d’hiver 2018 ?