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

Word Was Unable To Open The Datasource 2010

Contents

The excel file otherwise works normally, as does word itself. MS Word MS Office OfficeMate Freezes on Login Article by: Adiel OfficeMate Freezes on login or does not load after login credentials are input. Any help to correct this is greatly appreciated. . All the Word docs are already saved as mail merge documents, linked to an Access data table. his comment is here

If there are any > > security issues, they will probably appear there. 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 When I do find the source I return to the "Find" prompt again and again!!! for merge source.

Word Was Unable To Open The Data Source 2013

You can fix this problem by using "formatting switches" in Word: numbers formatted as percetages with 0 decimal places in Excel (22%) appear as 0.2187539 when merged into Word. Set up the data source how you want it, then save the mail merge main document. Word seems to be quite fussy about the SQL syntax - queries that work > elsewhere may fail in Word.

In Word 2003 (on a Windows 2003 network) we cannot save word merge files with a user -assigned data source. 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 Also, blank fields in Excel dispay the value zero (0) when merged in Word. Word Was Unable To Open The Data Source Mac Promoted by Neal Stanborough You've built an email signature using raw HTML code in Office 365, but you can't review how it looks with Transport Rules.

Wireless Networking Windows 8 Replacing Special Characters Using Find and Replace in Word Video by: AnnieCushing This Micro Tutorial well show you how to find and replace special characters in Microsoft Word Was Unable To Open The Data Source 2016 It really is just a couple of function calls - arghhh! when using OLE DB, but not this one Also, blank fields in Excel dispay the value zero (0) when merged in Word. Stay logged in Sign up now!

You will need to provide credit card, but they won't charge it until the incident is closed, and since they will determine that it's their problem (or even they manage to Kingsoft Writer Cannot Open Data Source Microsoft Access 2013 is configured in Options to allow dde 0 LVL 40 Overall: Level 40 MS Access 15 Windows OS 6 MS Word 3 Message Active today Expert Comment Yes, my password is: Forgot your password? Reply With Quote Quick Navigation Office Development Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Visual Basic Visual Basic .NET VB.net CodeBank Visual Basic 6

Word Was Unable To Open The Data Source 2016

Yu still need to specify the .odc in the Name parameter and the SQL statement, but you may find this works where the other approach does not. This will be demonstrated using Intel(R) Centrino(R) Wireless-N 2230 wireless card on Windows 8 operating system. Word Was Unable To Open The Data Source 2013 Your name or email address: Do you already have an account? Word 2013 Mail Merge Unable To Open Data Source All rights reserved.

Member Login Remember Me Forgot your password? http://webinweb.net/data-source/word-was-unable-to-open-datasource.html Which version of Windows? The first document opens (also verifying template name and file path is correct), but the second does not. Further, whether the Mailmerge task pane displays the "long" data source location details or just the short file name depends on whether the data source is in what Word thinks is Mail Merge Can't Open Data Source

Todd, Sep 27, 2003 #3 Peter Jamieson Guest > BTW, when I view an .odc in IE, all I see is the name of the .ODC file > and the comment i saved the file as a .docx document. Which version of Windows? weblink 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

This is tedious, but it may help. 3. Mail Merge Problems MSOfficeForums.com is not affiliated with Microsoft LinkBack LinkBack URL About LinkBacks Register Help Remember Me? ensure that Excel is listening to DDE conversations (Ensure that Excel Tools-Options-General-Ignore other Applicaitons is unchecked) b.

However, when I Finish& Merge, the data merged into Word look different than what it should and how it appears in Excel.

BTW, when I view an .odc in IE, all I see is the name of the .ODC file and the comment I added to it when I created it with Word. Anyway, if you try putting the file in a folder with a short pathname I think it will always work. You'll be able to ask questions about MS Office or chat with the community and help others. External Table Is Not In The Expected Format 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.

However, Word does not save the whole connection string (max 255 characters I think) and can truncate the pathname, so when you close and re-open the When you close the mail Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders What's New? Sign up now! check over here it connected well with the new data document i made.

It really is just a couple of function calls - arghhh! > > > > I think I've tried just about every conceivable parameter combination > > but without success. The closest thing I've come up with that sort of gets me to a work around is that some of the field headings have an underscore in them: First_Name, Last_Name, Address_1, Make This Easier Now LVL 40 Overall: Level 40 MS Access 15 Windows OS 6 MS Word 3 Message Active today Expert Comment by:Vadim Rapp ID: 389062992013-02-19 See if your ensure that Excel is listening to DDE conversations (Ensure that Excel Tools-Options-General-Ignore other Applicaitons is unchecked) b.

Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More... Tauter replied Dec 23, 2016 at 6:15 AM Loading... You may have to register before you can post: click the register link above to proceed. It does seem to depend on the data source and exactly what you have specified when creating the .odc (for example, if you haven't specified a table or view in the

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 In the Select recipients section of the Mail Merge Wizard (Step 3 of 6), I select the Data Source by browsing to the location of the this .txt file on my Thank you very much. Word 2003. "Peter Jamieson" wrote: On Friday, September 28, 2007 12:35 PM Peter Jamieson wrote: As far as I know, the main reasons why Word may have difficulty /re-/opening a data

Well, Word constructs a connection string containing whatever path name is required to specify the "database", and uses it to open the document. Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free. Peter Jamieson http://tips.pjmsn.me.uk On 05/02/2010 13:42, rickcstahl wrote: Sorry, I am using Windows XP.