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

Word Was Unable To Open The Datasource

Contents

The letters are created seperately in turn and then appended to each other as each letter has a unique barcode inserted so the mail merge data source is recreated by the What do I need to do to fix it and why did that change? If none of the above helps, a possible short term workaround is to copy/paste your Excel data into a new Word document and use that as the data source for your To start viewing messages, select the forum that you want to visit from the selection below. his comment is here

Word 2007 saves files differently to Word 2003, and although Word 2007 can open, read, and edit Word 2003 files, Word 2003 may not be able to read 2007 files correctly.If Copyright 2004-2016 Microsoft Office Word Forum - WordBanter. The time now is 07:27 AM. I did try opening the Excel file first but this did not work.

Word 2013 Word Was Unable To Open The Datasource

Password Site Map Home Register Authors List Today's Posts Search Web Partners Search Forums Show Threads Show Posts Advanced Search Go to Page... 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. 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 Any help to correct this is greatly appreciated.

For the first problem, use Alt-F9 to display the field codes. Next I choose th named or cell range which is "Entire Spreadsheet". The system returned: (22) Invalid argument The remote host or network may be down. Word Was Unable To Open The Data Source Mac I did not try to format the numbers because I do not believe this will work since I also have zero as some values that I do not want blanked out.

Thanks. "Peter Jamieson" wrote: 1. LinkBack Thread Tools Display Modes #1 03-14-2014, 12:02 PM meganadand Windows 7 64bit Office 2010 64bit Novice Join Date: Jan 2014 Posts: 3 "word was unable to open One or two people have reported that they have solved their DDE connection problems by changing their default Windows browser so that Internet Explorer is not the default. One thing they do not really mention - and it is related to the same problem that you can have on a network - is that the location plus the file

I tried the formatting suggestions, but when mail merged using OLE DB into word revealed instead of the percentage the following: Error ! Mail Merge Can't Open Data Source nancy4, Dec 15, 2009 #7 slurpee55 Joined: Oct 20, 2004 Messages: 7,837 Truly strange are the workings of Office sometimes.... Specifically, they have mentioned making Firefox the default. the file path, template name, etc.. 3.

Word Was Unable To Open The Data Source 2016

For the first problem, use Alt-F9 to display the field codes. However, when I Finish& Merge, the data merged into Word look different than what it should and how it appears in Excel. Word 2013 Word Was Unable To Open The Datasource By the way my Windows default is Internet Browser. Word Was Unable To Open The Data Source Word 2010 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

I haven't checked this myself. http://webinweb.net/data-source/word-was-unable-to-open-the-datasource-2010.html Also, if the Excel file has a really long name, you might want to rename the copy to something simpler, like mergefile.xls slurpee55, Dec 14, 2009 #6 nancy4 Thread Starter Your cache administrator is webmaster. Style Default Style Contact Us Help Home Top RSS Terms and Rules Copyright © TechGuy, Inc. Word 2013 Mail Merge Unable To Open Data Source

slurpee55, Dec 14, 2009 #4 nancy4 Thread Starter Joined: Dec 12, 2009 Messages: 3 2003 and thanks! I did try opening the Excel file first but this did not work. It appears after a couple of letters are processed, but there is no pattern to when it appears. http://webinweb.net/data-source/word-was-unable-to-open-datasource.html First, the original template with the mail merge fields unfilled, and the second is the template after the merge is complete.

You may have to register before you can post: click the register link above to proceed. Kingsoft Writer Cannot Open Data Source verify that the selected "database" is the excel filethat you expect. For the first problem, use Alt-F9 to display the field codes.

Then it tells me that it cannot open the data source.

This is tedious, but it may help. 3. Then it tells me that it cannot open the data source. Your Excel workbook has changed (possibly even been corrupted) in a way that makes it impossible for the Access/Jet OLE DB provider to get the data. Mail Merge Will Not Open Data Source Reply With Quote Apr 26th, 2010,11:31 AM #6 krazykarter View Profile View Forum Posts Thread Starter Junior Member Join Date Jan 2010 Posts 28 Re: MailMerge: Word is Unable to Open

Which version of Windows? Solved: word cannot open excel data source Discussion in 'Business Applications' started by nancy4, Dec 12, 2009. I haven't checked this myself. http://webinweb.net/data-source/word-unable-to-open-datasource.html Then I select the table "Sheet1$" without any errors.

James4630, Dec 13, 2009 #2 redoak Gone but never forgotten Joined: Jun 24, 2004 Messages: 6,782 Click "Report" and request your Thread be transferred as mentioned below. {redoak} redoak, Dec A dialogue box appears in the template saying "Access_Project.ADP is locked for editing by another user.", and asks if I want to open as read only, wait for notification, etc... when using OLE DB, but not this one Also, blank fields in Excel dispay the value zero (0) when merged in Word. 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.

Peter Jamieson View Public Profile View message headers Find all posts by Peter Jamieson Find all threads started by Peter Jamieson « Previous Thread | Next Thread » Thread Tools