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. it is likely to change to that folder if you create a test .csv in Word and save it. Please start a New Thread if you're having a similar issue.View our Welcome Guide to learn how to use this site. 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. his comment is here
However, the chances are that if Word can't open using OLE DB, it won't be able to do it with ODBC either. Reply With Quote Apr 25th, 2010,05:05 AM #4 westconn1 View Profile View Forum Posts PowerPoster Join Date Dec 2004 Posts 22,072 Re: MailMerge: Word is Unable to Open Data Source Would I have used the excel spreadsheet for this purpose before, but I get a message that "word cannot open the data source". click Options and select all four checkboxes.
I have yet to see anything productive latter Office is able to do that 2003 can't. 0 Message Accepted Solution by:Paul-bbc Paul-bbc earned 0 total points ID: 392863412013-06-29 dde not Thanks! On Thursday, July 31, 2008 9:55 PM Jerry Garnet wrote: Word 2003. When I do find the source I return to the "Find" prompt again and again!!!
Your cache administrator is webmaster. Attached Images 2014-03-14 13_56_08-Document1 - Microsoft Word.jpg (16.2 KB, 9 views) #2 03-14-2014, 12:23 PM macropod Windows 7 32bit Office 2010 32bit Administrator Join Date: Dec 2010 Location: Any suggestions??? Word 2013 Mail Merge Unable To Open Data Source They must hear that things don't work, otherwise they have no incentives to do them differently. 0 Message Author Comment by:Paul-bbc ID: 389207392013-02-23 I can understand Microsoft saying that dde
Advertisements do not imply our endorsement of that product or service. Word 2016 Was Unable To Open The Data Source 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 If you're not already familiar with forums, watch our Welcome Guide to get started. Here's what worked for me....
The OLE DB provider typically divides the location of a data source into a "database" and a "table". Mail Merge Can't Open Data Source If you are seeing the ODBC dialog box you would typically need to a. using the mail merge toolbar in Word 2007 to select the mail merge document type "Normal Word Document" - in 2007, it's in one of the dropdowns in the Mailings tab. 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://support.microsoft.com/kb/834699 Thanks for all your help. SEO by vBSEO ©2011, Crawlability, Inc. Word 2013 Word Was Unable To Open The Datasource same file paths, table name etc. Word Was Unable To Open The Data Source Word 2010 Yes, my password is: Forgot your password?
If the issue is in fact a program error, why would other letters generate successfully and this single template fail, when the file path and template name are correct, and the http://webinweb.net/data-source/word-was-unable-to-open-the-data-source-dbf.html to identify individaully selected records is stored (more or less). -- Peter Jamieson http://tips.pjmsn.me.uk "Mike DiCanio"
It is Windows 8 if that makes any difference. 0 LVL 39 Overall: Level 39 MS Access 32 MS Word 5 Windows OS 3 Message Active today Expert Comment by:als315 Simplifico replied Dec 23, 2016 at 7:15 AM Desktop freezes and stops... All rights reserved. weblink The merge document is a one page letter.
Set up the data source how you want it, then save the mail merge main document. Kingsoft Writer Cannot Open Data Source Facebook Twitter Google+ YouTube LinkedIn Tumblr Pinterest Newsletters RSS MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions Members Articles Videos Courses Contribute Products BackProducts Gigs Live Courses Vendor Services you find the data source.
in the Windows registry, but that's just my guess. If this is your first visit, be sure to check out the FAQ by clicking the link above. word 2010 has caused major problems (and i actually had 2007 and went back to 2003 in part because of mail merge problems). Mail Merge Will Not Open Data Source 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.
Wouldn't you love to be able to manage all signatures from one central location, easily design them and deploy them quickly to users. Read our Case Study Question has a verified solution. The two files are in the same folder on a network drive. 2. check over here When I select recipents and select the excel spreadsheet, it asks what table I want to use, so I select the spreadsheet I want, as that is the only options, after
Password Site Map Home Register Authors List Today's Posts Search Web Partners Search Forums Show Threads Show Posts Advanced Search Go to Page... are your mail merge document and data source in the same network folder? 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 When the module is run, two word documents open.
Find Out How Today 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 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" 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? How would I find out if it is? "Peter Jamieson" wrote: On Tuesday, August 21, 2007 5:12 PM Peter Jamieson wrote: Wen you have managed to open it, use Tools->Addins and
I am testing them on Office 2013 and when the Word document opens it complains cannot find dde source etc. To start viewing messages, select the forum that you want to visit from the selection below. 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, My files are on the network and have long descriptive file names.
The macro security settings are the same as the other templates that work.