I'll do my best to explain things as I go in the hope that other beginners can follow. It works fine with previous version of Microsoft Word. Connect with top rated Experts 16 Experts available now in Live! James Thurber Reply With Quote 02-20-2014,11:36 AM #3 Frosty View Profile View Forum Posts View Blog Entries View Articles VBAX Master Joined Feb 2011 Posts 1,475 Location I think the connection http://devstude.net/unable-to/word-error-word-was-unable-to-open-the-datasource-avery.php
Note, also, that Word 2002 has real problems with updating links to databases connected using OLEDB. Great for personal to-do lists, project milestones, team priorities and launch plans. - Combine task lists, docs, spreadsheets, and chat in one - View and edit from mobile/offline - Cut down View my complete profile Facebook Badge Kam-Hung Soh's ProfileCreate Your Badge Google Analytics Blog List Morva Shepley's Clockwork Moon Saw Star Wars long, long ago - Long ago, I took myself To work around the problem, the facility that returns a temporary filename will need to be 'wrapped' to return a filename with a particular extension.
It didn't make difference, unfortunately. I appreciate that, and no, I hadn't read the link. The database extension of the mail merge data file must be .mdb!In my original example, I was using a temporary filename which had a .tmp extension. Word Was Unable To Open The Data Source Word 2010 With Application.FileDialog(msoFileDialogFilePicker) .AllowMultiSelect = False If .Show <> 0 Then SelectedItems(1) = SourceDoc Else Exit Sub End If End With 'your connection string, also more easily separated with line breaks and
you're using it as your own variable, which you *never set* within the with block. Then I could do some further research on it. Office 2010 requires that the 'DatabaseName' parameter is filled in. https://support.microsoft.com/en-us/kb/833064 Use the "Insert Database" command from the DATA toolbar to insert the same data, with a link.
Have you tried to use a difference value on SubType parameter, such as wdMergeSubTypeWord and others. Word Was Unable To Open The Data Source Mac Login. 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. Visual Basic short-circuit evaluation of expressio... ► October (3) ► September (2) ► August (5) ► July (2) ► June (8) ► May (12) ► April (6) ► March (1) ►
This is because the .net function that returns temporary filenames will not be checking for an existing file with a different extension to ensure uniqueness. https://bytes.com/topic/access/answers/569451-error-5922-when-opening-mailmerge-document-word Blaq posted Nov 1, 2016 at 6:10 PM punctuation order fariz posted Oct 31, 2016 at 4:28 AM overwrite specific 'quick parts' - HELP! Word Was Unable To Open The Data Source Excel If you set SourceDoc= "xyz" then it does work... Word Was Unable To Open The Data Source 2016 It might work better than Access. 0 LVL 74 Overall: Level 74 MS Access 72 MS Office 15 MS Word 6 Message Expert Comment by:Jeffrey Coachman2011-02-08 "Now I created a
Any help would be very much appreciated, dirtychinchilla Last edited by dirtychinch; 02-20-2014 at 07:50 AM. but then you need to make sure (I believe) that they've also selected a valid file (how do you know they didn't select a power point presentation? What would be the disadvantage to defining a class as a subclass of a list of itself? with the parameter names and the passed values separated nicely ActiveDocument.MailMerge.OpenDataSource _ Name:=SourceDoc, _ ConfirmConversions:=False, _ ReadOnly:=False, _ LinkToSource:=True, _ AddToRecentFiles:=False, _ Revert:=False, _ Format:=wdOpenFormatAuto, _ SQLStatement:="SELECT * FROM `MailMerge`" 'Connection:=sConnection Word 2013 Mail Merge Unable To Open Data Source
You'll also need to modify the filter back to the way you want it to be. The actual filename of the Access database and its extension should not matter. Why did Merle cut off his hand instead of cutting the handcuffs? 18V from printer USB port. Your two references to: "H:\Jonathon Hunter Hill\AirMaster\AirMaster V 0.9.xlsm" should be replaced with: SourceDoc If I replace those references with SourceDoc, it then has the execution problem...
I have put this macro where macros record to in the project browser (under Normal, Modules, NewMacros), but this seems to have gone across all my documents?? Word 2013 Word Was Unable To Open The Datasource Now I created a new word template (dotx) with compatibility to previous version(2003). It connects to a SQL2005 via an ODBC connection that is configured to use NT authentication.
I didn't know that either. 0 Featured Post How to run any project with ease Promoted by Quip, Inc Manage projects of all sizes how you want. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate? Last Jump to page: Results 1 to 20 of 82 Thread: Run-time error '5922' - Mail Merge Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Member Login Remember Me Forgot your password?
However, when I modify it to where the user enters a value, and based on that value, will insert data into Word I get this error: run-time error '5922' word was Join the community of 500,000 technology professionals and ask your questions. Well I did that and I still get 5922 0 LVL 74 Overall: Level 74 MS Access 72 MS Office 15 MS Word 6 Message Expert Comment by:Jeffrey Coachman2011-02-08 OK. that whole File Picker dialog exposes you to a lot of different potential inputs, if you're not validating what you get back.
E: Fixed it, had to go under TemplateProject Reply With Quote 02-21-2014,04:36 AM #9 macropod View Profile View Forum Posts View Blog Entries View Articles VBAX Guru Joined Jul 2008 Posts with the parameter names and the passed values separated nicely ActiveDocument.MailMerge.OpenDataSource _ Name:=SourceDoc, _ ConfirmConversions:=False, _ ReadOnly:=False, _ LinkToSource:=True, _ AddToRecentFiles:=False, _ Revert:=False, _ Format:=wdOpenFormatAuto, _ SQLStatement:="SELECT * FROM `MailMerge`" 'Connection:=sConnection I spent some time browsing the web to investigate the run-time error, when it would have been more effective to first check the arguments in the subroutine call. Note: Comments are moderated to filter comment spam.
Would you mind sharing the source code about this issue? I've got it working manually, but need to automate the process for our users. I will try what you suggest. If you do this manually, does it work? 0 Message Author Comment by:zachvaldez2011-02-07 yes 0 Message Author Comment by:zachvaldez2011-02-07 I'd like to place it in a button clivk 0
Originally Posted by macropod As for: there's not much point in defining and selecting a source document, then not using it! The whole point about cross-posting etiquette that you'll read there is that the forums aren't linked and, by not applying the etiquette (which amounts to nothing more than common courtesy), you I used the macro trick to get a connection string that would work and then I changed one thing at time to figure out why my original code did not work. asked 5 years ago viewed 875 times Blog Stack Overflow Podcast #93 - A Very Spolsky Halloween Special Related 1How can I best use VBA in Access or Excel to test
Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free. If you just want to check out a tool that creates a Select Case fu… MS Word Adding Watermarks to Your Documents Video by: Tony This video walks the viewer through