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 Please start a New Thread if you're having a similar issue.View our Welcome Guide to learn how to use this site. Copyright ©2004-2016 Microsoft Office Word Forum - WordBanter. Here's the strange part. his comment is here
This may have been fixed in a later SP, and I believe was fixed in Word 2003. Thanks for the help. hroberts View Public Profile View message headers Find all posts by hroberts Find all threads started by hroberts Ads #2 December 4th 09, 03:06 AM posted to microsoft.public.word.docmanagement Peter When I try to import the data into mail merge, none of my tables show up (see attachment).
When the module is run, two word documents open. This second date is the issue. you /may find that data source info. What happens in some cases is this: a.
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. Excel merge into Word:"unable to open data source" « Previous Thread | Next Thread » Thread Tools Display Modes #1 September 20th 07, 04:42 PM posted to The application makes use of word merge fields in batch letters. Word 2013 Mail Merge Unable To Open Data Source MSOfficeForums.com is not affiliated with Microsoft LinkBack LinkBack URL About LinkBacks Register Help Remember Me?
Are you sure your workbook is still in the .xls format and hasn't been changed to the newer .xlsx format? __________________ Cheers, Paul Edstein [MS MVP - Word] #3 Thank you very much. Please try again now or at a later time. 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
With my merge document open in Word 2003 I click Letters and Mailings on the Tools menu, and then click Mail Merge. Mail Merge Can't Open Data Source Stay logged in Sign up now! I have used the excel spreadsheet for this purpose before, but I get a message that "word cannot open the data source". On Thursday, July 31, 2008 9:55 PM Jerry Garnet wrote: Word 2003.
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... 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. Word 2013 Word Was Unable To Open The Datasource 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. Word Was Unable To Open The Data Source Word 2010 To start viewing messages, select the forum that you want to visit from the selection below.
Thanks. this content Then it tells me that it cannot open the data source. click Options and select all four checkboxes. Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders What's New? Word Was Unable To Open The Data Source Mac
All times are GMT -5. 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. Awkward, but I believe it works. (You can also use VBA Activedocument.mailMerge.DataSource.Close in Word 2003/2007 to achieve a similar effect without losing the document type). -- Peter Jamieson http://tips.pjmsn.me.uk "Doug Pruiett" weblink This does not make sense to me.
So can you explain why that would be different for barcodes?Kees Flag Permalink This was helpful (0) Collapse - problem with control chars by rachel_c / August 27, 2009 6:39 PM Mail Merge Will Not Open Data Source If this is your first visit, be sure to check out the FAQ by clicking the link above. It continually asks to locate the data source and if you point it to the file it just continually loops back and asks for the file location again.
I didn't do anything different that I have before. is cached in the .doc. i create a new "make mail merge" document. External Table Is Not In The Expected Format to identify individaully selected records is stored (more or less). -- Peter Jamieson http://tips.pjmsn.me.uk "Mike DiCanio"
I wonder if that is when the problem started.Scenario - Use Word 2007 to do what you normally do, save everything. I also tried copying the issue template to the same folder as another template that works, and this also did not work. 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 http://webinweb.net/data-source/word-was-unable-to-open-the-data-source-excel-2007.html 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.
Your cache administrator is webmaster.