Home > Data Source > Word Was Unable To Open The Datasource Office 2010

Word Was Unable To Open The Datasource Office 2010

Contents

For the first problem, use Alt-F9 to display the field codes. To start viewing messages, select the forum that you want to visit from the selection below. slurpee55, Dec 15, 2009 #8 Sponsor This thread has been Locked and is not open to further replies. Code: Dim WordObj As Word.Application WordObj.Documents.Add template:=filepath & "\" & filenam, _ NewTemplate:=False WordObj.OpenDataSource _ name:=CurrentProject.Path & "\" & CurrentProject.name, _ LinkToSource:=True, _ sqlStatement:=sqlStatement Thanks in advance. http://webinweb.net/data-source/word-was-unable-to-open-the-datasource-2010.html

If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.Would you like to participate? In the scenario you describe I would expect any such info to be stored in a DSN, .udl or .odc file I'm not sure if the above answers your question. I am trying to avoid reconnecting over 100 documents, is there a fix or a property somewhere? If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post).

Word Was Unable To Open The Data Source Excel

If you see \*Mergeformat in there, delete it. I connect to a data source and then the next time I open the Word document it either cannot find the data source or asks me to find the data source. It is certainly possible for Internet Explorer or a plug-in to interfere with DDE as a whole. Does anyone have any ideas of things I could try to fix this?

All rights reserved. It is more likely to work if you do not have more columns than Word can have in a table, and/or your data is quite simple (no multiline data, no "delimiter I also tried copying the issue template to the same folder as another template that works, and this also did not work. Word Was Unable To Open The Data Source Mac Modify the report design after the wizard is done to make it look better.

This second date is the issue. Is it Vista? 2. Suppose you have { MERGEFIELD mypercentage } Select it, and press ctrl-F9 to surround it with a new pair of field code braces: { { MERGEFIELD mypercentage } } then insert I followed the suggestion of prompting the data source before opening and I can choose "MS Excel Worksheet via DDE (*.xls) when prompted.

In my own company, I still run windows xp and office 2003. Mail Merge Can't Open Data Source Macboatmaster replied Dec 23, 2016 at 7:00 AM Adobe Flash Player Download... Disruptive posting: Flaming or offending other usersIllegal activities: Promote cracked software, or other illegal contentOffensive: Sexually explicit or offensive languageSpam: Advertisements or commercial links Submit report Cancel report Track this discussion The error appears when batch letters are created in an application written in Delphi.

Word Was Unable To Open The Data Source 2013

There can in theory be other problems that would cause this problem, but in most of those cases you would be unlikely to connect at all. -- Peter Jamieson http://tips.pjmsn.me.uk "Mike It appears after a couple of letters are processed, but there is no pattern to when it appears. Word Was Unable To Open The Data Source Excel Reply With Quote Apr 23rd, 2010,04:44 PM #2 westconn1 View Profile View Forum Posts PowerPoster Join Date Dec 2004 Posts 22,072 Re: MailMerge: Word is Unable to Open Data Source if Word Was Unable To Open The Data Source 2016 I have Word option 'confirm conversion on open' checked and the db and word docs are all in trusted locations. 0 Comment Question by:Paul-bbc Facebook Twitter LinkedIn https://www.experts-exchange.com/questions/28034260/Word-2013-mail-merge-error-cannot-find-dde-source-to-Access-table.htmlcopy Best Solution byPaul-bbc

all of this is kind of ridiculous and word should fix this problem. http://webinweb.net/data-source/word-unable-to-open-datasource.html Which leaves me a bit stuck. Then I select the table "Sheet1$" without any errors. If you are experiencing a similar issue, please ask a related question Suggested Solutions Title # Comments Views Activity How do I open my Dashlane exported backup file (.dash)? 4 54 Word 2013 Mail Merge Unable To Open Data Source

I renamed the copied template to have the same name, and copy/pasted the contents of the issue template. same file paths, table name etc. I followed the suggestion of prompting the data source before opening and I can choose "MS Excel Worksheet via DDE (*.xls) when prompted. weblink rickcstahl View Public Profile View message headers Find all posts by rickcstahl Find all threads started by rickcstahl #4 February 6th 10, 02:01 PM posted to microsoft.public.word.mailmerge.fields Peter Jamieson

If you have not tried already, try opening your Excel document first, then making the connection. Kingsoft Writer Cannot Open Data Source If you save as .htm I think it looks more as if enough info. a. ...an Access table, the "database" is the Access .mdb file that contains all the data, and the table is a table or query within that .mdb b. ...a text file,

Track this discussion and email me when there are updates If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and

Peter Jamieson http://tips.pjmsn.me.uk On 05/02/2010 02:15, rickcstahl wrote: My problem is that my Excel data is not being "mail merged" into Word. Wednesday, December 10, 2014 6:01 AM Reply | Quote Answers 0 Sign in to vote As far as I know, you cannot merge from a .xlsx data source in Mac Word The error message refers to an .xls format, but the document is in and .xlsx format. Mail Merge Will Not Open Data Source e.g.

The time now is 01:24 PM. - Contact Us - Microsoft Word Forum WordBanter forum home - FAQ - Links - Privacy Statement - Top Powered by vBulletin Version 3.6.4Copyright ©2000 how long is the pathname of the data source? On the csv file that does not work, the source that the recipients are currently selected from appears as: [:\foldername\source.cs] in "source.csv" If I make a csv file from scratch and http://webinweb.net/data-source/word-was-unable-to-open-datasource.html Specifically, they have mentioned making Firefox the default.

Simplifico replied Dec 23, 2016 at 7:15 AM Desktop freezes and stops... right now you have non-working software in your company, you are spending time and money to fix it. Which version of Windows? Any suggestions???

WE GET THE SAME MESSAGE - Word cannot find its data source. I haven't checked this myself. Privacy Policy Ad Choice Terms of Use Mobile User Agreement cnet Reviews All Reviews Audio Cameras Laptops Phones Roadshow Smart Home Tablets TVs News All News Apple Crave Internet Microsoft Mobile One uses getdate(), the other uses a date from a table.

It looks like Word doesn't like either the long path or not using a Drive letter.