unable to import excel file into word via dde to make labels

Hello, I'm trying to import an excel file into word to make labels.  I have gone through all the steps and it says that "word cannot re-establish a dde connection to Microsoft excel to complete the current task."


I have gone through all the threads and tried different things (checking and unchecking the "ignore other applications that use dde" as well as trying to import it using "ole database file"



none have worked.  I also tried importing it as a csv file, and as a excel 97-2003 file.



I'm using word/excel 2013 through office 365.


thanks for your help.

I assume that you are using Mail Merge.  Why aren't you using the default OLE DB Database Files method of connecting to the data source?


If you want to use DDE for some reason, try first starting Excel and perhaps have the data source open in Excel.

Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com
It's time to replace ‘Diversity, Equity & Inclusion’ with ‘Excellence, Opportunity & Civility’ - V Ramaswamy

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated October 5, 2021 Views 377 Applies to: