Home > Data Source > Word Unable To Open Datasource

Word Unable To Open Datasource

Contents

I also tried copying the issue template to the same folder as another template that works, and this also did not work. Don't know if this will make a difference or not with your suggestions to correct the display of zero in reference to a number. Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Microsoft Word Help Mail Merge - Cannot open data source Author Name Remember Me? Privacy statement  © 2016 Microsoft. his comment is here

Password Site Map Home Register Authors List Today's Posts Search Web Partners Search Forums Show Threads Show Posts Advanced Search Go to Page... you probably save the mail merge main document to try to save the new daa source location. As far as the zeros being displayed, sometimes I have zero as an Excel value which I want to appear in Word but other fields in Excel are blank but when I tried changing the filename to .xls (originally .xlsx) but it didn't work.

Word 2013 Word Was Unable To Open The Datasource

Results 1 to 6 of 6 Thread: [RESOLVED] MailMerge: Word is Unable to Open Data Source Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to In Word 2002 there is a problem where the data source is lost if you apply a filter or sort criteria to your data source. nancy4, Dec 14, 2009 #5 slurpee55 Joined: Oct 20, 2004 Messages: 7,837 According to MS, the reasons for this are: * Your data source is not located on your computer--for example, If you have not tried already, try opening your Excel document first, then making the connection.

If you have not tried already, try opening your Excel document first, then making the connection. Advanced Search VBForums Visual Basic Office Development [RESOLVED] MailMerge: Word is Unable to Open Data Source If this is your first visit, be sure to check out the FAQ by clicking Also, blank fields in Excel dispay the value zero (0) when merged in Word. Word Was Unable To Open The Data Source Mac Unfortunately, (d) does not always work as you would expect, Word seems to retain the original daa source information and to treat the new data source as "temporary".

I followed the suggestion of prompting the data source before opening and I can choose "MS Excel Worksheet via DDE (*.xls) when prompted. So for example, if the data source is... However, the chances are that if Word can't open using OLE DB, it won't be able to do it with ODBC either. just a rectangular table of data with no formulas etc.) it is probably worth exporting your data to a format such as .csv, then recreating your workbook and re-importing the data.

rickcstahl View Public Profile View message headers Find all posts by rickcstahl Find all threads started by rickcstahl « Previous Thread | Next Thread » Thread Tools Show Printable Version Mail Merge Can't Open Data Source Then in lowr left task bar it briefly says "Opening file . . . ." but then I am prompted with Word error "Word was unable to open the data source." Is it Vista? 2. how i fixed word 2010 mail merge won't open data file From: Jim Hanson Date: Sat, 18 Sep 2010 10:01:50 GMT i have used my mail merge files for years

Word 2016 Was Unable To Open The Data Source

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 I haven't checked this myself. Word 2013 Word Was Unable To Open The Datasource Style Default Style Contact Us Help Home Top RSS Terms and Rules Copyright © TechGuy, Inc. Word Was Unable To Open The Data Source Word 2010 the connection information saved by Word when you close a working mail merge main document is truncated in such a way that Word loses essential information about the location of the

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 This information was helpful. unless you happen to know that 0 always means that the original entry was blank. rickcstahl View Public Profile View message headers Find all posts by rickcstahl Find all threads started by rickcstahl Ads #2 February 5th 10, 09:45 AM posted to microsoft.public.word.mailmerge.fields Peter Word 2013 Mail Merge Unable To Open Data Source

The time now is 01:22 PM. - Contact Us - Microsoft Word Forum WordBanter forum home - FAQ - Links - Privacy Statement - Top Powered by vBulletin Version 3.6.4Copyright ©2000 Which leaves me a bit stuck. Next I choose th named or cell range which is "Entire Spreadsheet". weblink Then it tells me that it cannot open the data source.

This is tedious, but it may help. 3. Kingsoft Writer Cannot Open Data Source Thanks. "Peter Jamieson" wrote: 1. Thanks. "Peter Jamieson" wrote: 1.

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

But even after we do that, Word Merge cannot find the data source. The data is a simple csv file with only 10 fields. The first document opens (also verifying template name and file path is correct), but the second does not. Mail Merge Will Not Open Data Source All times are GMT -5.

further, it actually emailed better and faster (i have to use a hotfix to email from word mail merge to live mail desktop email program). 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 Mail Merge - Cannot open data source « Previous Thread | Next Thread » Thread Tools Display Modes #1 December 3rd 09, 07:45 PM posted to microsoft.public.word.docmanagement http://webinweb.net/data-source/word-was-unable-to-open-datasource.html The excel file otherwise works normally, as does word itself.

This site is completely free -- paid for by advertisers and donations. This module is called in many places in this project, and there are only 2 specific mail merge templates that do not work. 2. For the first problem, use Alt-F9 to display the field codes. Also, blank fields in Excel dispay the value zero (0) when merged in Word.

You may have to register before you can post: click the register link above to proceed. If you're not already familiar with forums, watch our Welcome Guide to get started. But a. If you see \*Mergeformat in there, delete it.

Things you might have done to your workbook that could affect this include stuff such as creating lists/databases/outlines within the relevant worksheet If your workbook/worksheet is very simple (e.g. Last edited by krazykarter; Apr 26th, 2010 at 11:00 AM. For the second problem you can change { MERGEFIELD mynumber } to { MERGEFIELD mynumber \#"0.00;-0.00;''"} (or if it is your percentage field that can have blanks, use { ={ MERGEFIELD i was doing a mail merge with a word document (.doc) with a table.

I followed the suggestion of prompting the data source before opening and I can choose "MS Excel Worksheet via DDE (*.xls) when prompted. By the way my Windows default is Internet Browser.