for merge source. Privacy statement © 2016 Microsoft. 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 Sorry, there was a problem flagging this post. his comment is here
click Options and select all four checkboxes. You may have to register before you can post: click the register link above to proceed. 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 All the Word docs are already saved as mail merge documents, linked to an Access data table.
The time now is 07:20 AM. Tauter replied Dec 23, 2016 at 6:15 AM Loading... Problem is how to use dde as connection on Windows 8 to ,mdb file 0 Message Author Comment by:Paul-bbc ID: 389024692013-02-18 Points increased for a solution that will allow me Occassionally certain control characters cropped up in the barcode that threw up an error when using mail merge.
Also, if the Excel file has a really long name, you might want to rename the copy to something simpler, like mergefile.xls slurpee55, Dec 14, 2009 #6 nancy4 Thread Starter Any suggestions??? Sooner or later you will have to do it anyway, so maybe it's better to use the opportunity and actually re-do all the documents. Word Was Unable To Open The Data Source Mac An error has started to appear in the last couple of weeks: "word was unable to open the data source".
Tech Support Guy is completely free -- paid for by advertisers and donations. Word Was Unable To Open The Data Source Word 2010 If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). I didn't do anything different that I have before. I would assume the connection string is set somewhere else.
To start viewing messages, select the forum that you want to visit from the selection below. Mail Merge Can't Open Data Source If you are experiencing a similar issue, please ask a related question Suggested Solutions Title # Comments Views Activity SQL Query 3 30 12d Windows 10 with Parallels will not start Question has a verified solution. I am fairly sure that there is no error in the filepath or filename, since the correct document does open, but the mergefields are never filled.
Microsoft Access 2013 is configured in Options to allow dde 0 LVL 40 Overall: Level 40 MS Access 15 Windows OS 6 MS Word 3 Message Active today Expert Comment For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200! Word 2013 Word Was Unable To Open The Datasource Wednesday, December 10, 2014 6:01 AM Reply | Quote Answers 0 Sign in to vote As far as I know, you cannot merge from a .xlsx data source in Mac Word Word 2016 Was Unable To Open The Data Source Windows 10 Windows 8 Windows Server 2012 Windows Server 2008 Windows 7 OS Security Obtaining an object variable for a running instance of Microsoft Access.
Windows 8 Downloading and Installing SARDU on Windows 8 Video by: Thomas The viewer will learn how to successfully download and install the SARDU utility on Windows 8, without downloading adware. this content by Kees Bakker / August 27, 2009 6:39 AM PDT In reply to: "word was unable to open the data source" error message But I wondered why when I read "each If there are really so many thousand of them, maybe you can even automate clicking the buttons by macro, perhaps, or by some software like Automate. 0 Message Author Comment All times are GMT -5. Word 2013 Mail Merge Unable To Open Data Source
If you are seeing the ODBC dialog box you would typically need to a. You may have to register before you can post: click the register link above to proceed. 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 http://webinweb.net/data-source/word-unable-to-open-data-source.html 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.
the file path, template name, etc.. 3. Kingsoft Writer Cannot Open Data Source All rights reserved. Is the damage they make any worse than the one from the "malicious hackers"?
Please try the request again. This will be demonstrated using Windows 8 operating system. Click here to join today! Mail Merge Will Not Open Data Source It will explain exciting features how to maximize your PC through these apps.
My guess is that it may be permissions or perhaps not a dde driver in Windows 8 perhaps. Promoted by Acronis Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, &more! Connect with top rated Experts 13 Experts available now in Live! http://webinweb.net/data-source/word-was-unable-to-open-the-data-source-mac.html When the project was created, it was associated with the SQL database.
Advertisement Recent Posts L1c63x64.sys Atheros LAN driver... Stay logged in Sign up now! Yes, this constant talk about "security" is major reason to contact them. 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.
Would it just use this setting as the connection? The system returned: (22) Invalid argument The remote host or network may be down. 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