With objWordDoc .MailMerge.OpenDataSource _ Name:=strExportFullyQualifiedName, Format:=wdOpenFormatAuto, _ ConfirmConversions:=False, ReadOnly:=False, SubType:=wdMergeSubTypeAccess, AddToRecentFiles:=False .MailMerge.Destination = wdSendToNewDocument .MailMerge.MainDocumentType = wdDirectory .MailMerge.SuppressBlankLines = True End With Thanks ! Something I tend to do just as a sanity check is double-click on the .odc file (which is in fact an HTML file that uses some "behaviours" defined in DATACON.HTC when Sign up now! Try moving your Excel file (or making a copy) on your Desktop and also have your Word document there and try again. Check This Out
The preconditions are correct, i.e. The SQL queries work fine on their own too. > > > > I've tried recording a macro, then translating the VBA into C#, but to > > no avail. It really is just a couple of function calls - arghhh! > > I think I've tried just about every conceivable parameter combination > but without success. In particular, if you are > /not/ using SQL Server integrated security, the SQL Server user name and > password will have to be recorded in the .odc, or in the click
Does anyone have any ideas of things I could try to fix this? Why are Stormtroopers stationed outside the Death Star near the turbolaser batteries adjacent to Bay 327? What caused my meringue to fall after adding cocoa?
Thanks again, Todd. "Peter Jamieson" <> wrote in message news:<>... > Two things you could look at: > a. 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? Please start a New Thread if you're having a similar issue.View our Welcome Guide to learn how to use this site. Word Was Unable To Open The Data Source Mac You'll be able to ask questions about MS Office or chat with the community and help others.
When I try to import the data into mail merge, none of my tables show up (see attachment). Word 2013 Word Was Unable To Open The Datasource changing location of texmf folder for use across multiple computers (OS X / Apple) Can a mathematician review my t-shirt design? Also, the SQL statement is correct; I have run it in Query Analyzer and it returns the correct results. http://www.vbforums.com/showthread.php?612378-RESOLVED-MailMerge-Word-is-Unable-to-Open-Data-Source Mail Merge is a function in MS Word, which as far as I know, can only work with Word files.
Sign Up Now! Word 2013 Mail Merge Unable To Open Data Source Is it possible to have 3 real numbers that have both their sum and product equal to 1? I think I've tried just about every conceivable parameter combination but without success. simulation with kinetic friction, weird results What are Iron nuggets and what can they be used for?
Peter Jamieson, Sep 28, 2003 #4 Advertisements Show Ignored Content Want to reply to this thread or ask your own question? http://stackoverflow.com/questions/6654651/run-time-error-5922-when-running-mail-merge-in-word-connecting-to-sql2005-db-vi Click here to join today! Word Was Unable To Open The Data Source 2010 Your name or email address: Do you already have an account? Word 2016 Was Unable To Open The Data Source I'm using Word 2002 and the data is coming from SQL Server 2k.
Similar Threads - Solved word cannot MS Word 2016: how to insert simple jpegs! his comment is here 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 Word seems to be quite fussy about the SQL syntax - queries that work elsewhere may fail in Word. Browse other questions tagged ms-access vba ms-word or ask your own question. Word Was Unable To Open The Data Source Word 2010
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 Mail Merge Can't Open Data Source Word needs to ALSO open the file, but with OpenExclusive it is possible for you to lock yourself out. After I confirm this in word, I get a a run time error.
Using flags vs. Word seems to be quite fussy about the SQL syntax - queries that work > > elsewhere may fail in Word. How to use LINQ to find a sum? Kingsoft Writer Cannot Open Data Source Save your template (the .doc or .dot file) after you have said no to the merging.
bj nick, Dec 10, 2016, in forum: Business Applications Replies: 3 Views: 162 DaveA Dec 14, 2016 How to Save & Reuse a Word 2007 Mail Merge Template jarhtmd, Dec 6, For example (assuming you're still getting the SQL prompt upon opening the document), when the 'Data Link Properties' dialogue pops up, simply add the missing 'x' to the end of the objWord.Application.Visible = True 'Set the mail merge data source objDoc.MailMerge.OpenDataSource Name:="C:\cmos\cmos.mdb", LinkToSource:=True, Connection:="TABLE tblMailMerge_Temp_Full", SQLStatement:="SELECT * FROM tblMailMerge_Temp_Full" 'Execute the mail merge. http://popupjammer.com/unable-to/unable-to-connect-to-data-source-sql-08001.html Two of the values in the view are dates.
I am running Access 2003. The time now is 04:55 PM. -- Default Style -- Mobile Style Contact Us - Privacy Statement - Top Powered by vBulletin Version 3.8.1Copyright ©2000 - 2016, Jelsoft Enterprises Ltd. Welcome to the Microsoft Office Forums where you can ask questions or find answers on anything related to Word, Excel, Outlook, Access or any of the other Office applications. When the project was created, it was associated with the SQL database.
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 asked 5 years ago viewed 888 times Blog Stack Overflow Gives Back 2016 Developers, Webmasters, and Ninjas: What’s in a Job Title? Microsoft Office Forums Forums > Archive > Newsgroup Archive > Word Newsgroups > Word Mail Merge > Forums Forums Quick Links Search Forums Recent Posts Members Members Quick Links Notable Members