Home > Data Source > Word Was Unable To Open Data Source Excel

Word Was Unable To Open Data Source Excel

Contents

Staff saves the document. However, when you save a mailmerge main doc. The string will be saved either in the connection string, or in the SQLStatement, or split across the two, depending on how Word chose to make the connection (it may choose Peter Jamieson wrote in message news:[email protected] On Monday, August 20, 2007 11:38 AM Jan wrote: I'm having a very similar problem. his comment is here

Macboatmaster replied Dec 23, 2016 at 7:00 AM Adobe Flash Player Download... longer or shorter than the pathname you used when testing on a local drive? - the total length consists of all the charaters in \\computername\sharename\folders`filename.ext c. 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 http://support.microsoft.com/kb/834699 Thanks for all your help.

Word 2013 Word Was Unable To Open The Datasource

Any suggestions??? Mike "Peter Jamieson" wrote: On Friday, September 28, 2007 2:59 AM Peter Jamieson wrote: Is this also Word 2007? -- Peter Jamieson http://tips.pjmsn.me.uk On Friday, September 28, 2007 9:56 AM MikeDiCani First, the original template with the mail merge fields unfilled, and the second is the template after the merge is complete. Word cannot find the data source, so it prompts you (find it, or remove the data source) c.

If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members. If you are able to test the same document and mail merge source on a much shorter network path and it still does not work, I think that would help establish An error has started to appear in the last couple of weeks: "word was unable to open the data source". Word Was Unable To Open The Data Source Mac It looks like Word doesn't like either the long path or not using a Drive letter.

so, i took the table in my data document and copied the data (but not really the table) into a table in a new document. 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 I also tried copying the issue template to the same folder as another template that works, and this also did not work. Mike "Peter Jamieson" wrote: On Friday, October 12, 2007 12:53 PM Peter Jamieson wrote: 1.

Set up the data source how you want it, then save the mail merge main document. Mail Merge Can't Open Data Source Join our site today to ask your question. Thread Status: Not open for further replies. 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

Word 2016 Was Unable To Open The Data Source

Peter Jamieson http://tips.pjmsn.me.uk On 03/12/2009 18:45, hroberts wrote: I'm trying to mail merge a word document with an excel spreadsheet. But then I get the second clue. Word 2013 Word Was Unable To Open The Datasource 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, Word Was Unable To Open The Data Source Word 2010 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

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 this content Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next dim all variables as required 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... 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 Word 2013 Mail Merge Unable To Open Data Source

Solved: word cannot open excel data source Discussion in 'Business Applications' started by nancy4, Dec 12, 2009. Loading... The problem ended up being solved by the following microsoft support doc. weblink 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,

An application such as Word that uses OLE DB to get data usually specifies the database part of the data source's locatoin in a /Connection string/, and specifies the "table" part Kingsoft Writer Cannot Open Data Source Hi Kees,Barcode font Code128 is used. Sorry, there was a problem flagging this post.

you probably save the mail merge main document to try to save the new daa source location.

MSOfficeForums.com is not affiliated with Microsoft LinkBack LinkBack URL About LinkBacks Register Help Remember Me? My files are on the network and have long descriptive file names. Short URL to this thread: https://techguy.org/885079 Log in with Facebook Log in with Twitter Log in with Google Your name or email address: Do you already have an account? Mail Merge Will Not Open Data Source The application makes use of word merge fields in batch letters.

So the only things you can do are a. Join over 733,556 other people just like you! If you are seeing the ODBC dialog box you would typically need to a. http://webinweb.net/data-source/word-was-unable-to-open-the-data-source-excel-2007.html The only option is to remove the headers.

This may have been fixed in a later SP, and I believe was fixed in Word 2003. I am far from an expert in VBA, I havn't even been using it for 4 months, so I could be missing the issue/point entirely. A few questions: a. http://tips.pjmsn.me.uk/t0003.htm for a discussion of some of the issues surrounding connections to Excel files, for example) b.

I can re-select the same data source and generate a document but when I save the template and re-open it, the same process occurs. 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. Tech Support Guy is completely free -- paid for by advertisers and donations.