Hi, I have installed office 2013 on a pc and used excel to run a query on a database and created a .qry query so I can use this data in word mail merge.

The query runs ok and returns the data.

However, when I go to take the data in through mail merge it comes up with a message "Confirm data source" ( I enabled this after  reading kb article below) so I select "MS query files via DDE(*.qry, *.dqy)" as this is a .dqy I select it. It says at the bottom of the screen word is starting query then comes up with the error  "Word could not re-establish a DDE connection to Microsoft Query to complete the current task".

I have re-did the query from scratch and no difference I tried the recommend kb article 918594 and it still doesn't work.

I recreated the odbc link and still no joy.

Has anyone come across this and have they a solution I would be grateful.

Thanks

Tom

• Edited by tomconaty Friday, July 26, 2013 1:47 PM

Anyone find a solution to this?  Works perfectly with Word 2010 but when I upgrade to Word 2013 via Office 365 get this DDE error.  The ODBC link is working and the data is initially pulled into the Word merge fields but when you want to open MS Query to change the selection criteria, we get the error.  Seems like there is a disconnect between Word 2013 and MS Query.

Of note is that with Office 365, there is no way to specify the install options for Office and tell it to install MS Query.  Perhaps this is the problem??  Is anyone able to access MS Query via Word 2013?  If so, what version of Word 2013 are you using (Office 365 or stand-alone)?

Thanks,

Ed