Word Error 5922
Tuesday, October 19, 2010 3:45 AM Reply | Quote 0 Sign in to vote Hi Andy I recommend you record a VBA macro while creating a manual link (as an end-user) Can you tell me why these are not both bugs (especially the second one)? I also guess it may be related to be SubType parameter. It didn't make difference, unfortunately. click site
Setting the .AllowMultiSelect to false is good... That will tell you about the syntax Word wants to have - and Word is very finicky about data source connections. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: … MS PowerPoint Office Suites-Other MS Office Advertise Software Salariman Nuts and bolts about programming applications, databases and spreadsheets. https://social.msdn.microsoft.com/Forums/office/en-US/02d95732-6853-41e9-8d19-4ad5237a1845/error-5922-doing-a-mail-merge-with-word-2010?forum=worddev
Word Was Unable To Open The Data Source Excel
Member Login Remember Me Forgot your password? Reply With Quote 02-21-2014,03:21 AM #7 dirtychinch View Profile View Forum Posts View Blog Entries Visit Homepage View Articles VBAX Regular Joined Feb 2014 Location Ashford, Surrey, UK Posts 64 Location The actual filename of the Access database and its extension should not matter.
I appreciate that, and no, I hadn't read the link. I've got it working like this: Sub MailMerge() Dim SourceDoc As String Dim SelectedItems(1) As String Dim sConnection As String With Application.FileDialog(msoFileDialogFilePicker) .AllowMultiSelect = False If .Show <> 0 Then SelectedItems(1) Post your question and get tips & solutions from a community of 418,710 IT Pros & Developers. Word Was Unable To Open The Data Source Word 2010 If you set SourceDoc= "xyz" then it does work...
That wrapper will have to check to see if the temporary filename with the new extension already exists in the temporary folder and then try generating another temp filename if it Word Was Unable To Open The Data Source 2013 Please try again later After clicking 'Okay' the following error message is returned: Run-time Error '5922' the code in quotes is highlighted ********************* Expand|Select|Wrap|Line Numbers DimwdAppAsWord.Application SetwdApp=CreateObject("Word.Application") wdApp.Visible=False xPathDoc="C:\DocumentsandSettings\BDASoftware\LienWaiver.doc" DimwdAsWord.Document Setwd=wdApp.Documents.Open(xPathDoc,,True) Dec 11 '06 #5 reply Message Cancel Changes Post your reply Join Now >> Sign in to post your reply or Sign up for a free account. Can you check Help for the correct syntax?
My datasource change from Boat .mdb to Boat .accdb. Word Was Unable To Open The Data Source Mac Andy andy Marked as answer by andy pelkey Friday, October 29, 2010 6:15 PM Friday, October 29, 2010 6:14 PM Reply | Quote Microsoft is conducting an online survey to understand This gives you a subroutine you can use in other places as well, if you wanted to change filters or something. Advertisements Latest Threads How to create bulleted to-do list using two styles?
- First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone.
- Also, in what file format is the Access database?Cindy Meister, VSTO/Word MVP Marked as answer by Bessie Zhao Monday, October 25, 2010 9:26 AM Unmarked as answer by andy pelkey Friday,
- 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?
- Powered by vBulletin Version 4.2.2 Copyright © 2016 vBulletin Solutions, Inc.
Word Was Unable To Open The Data Source 2013
Reply With Quote 02-21-2014,08:39 AM #13 dirtychinch View Profile View Forum Posts View Blog Entries Visit Homepage View Articles VBAX Regular Joined Feb 2014 Location Ashford, Surrey, UK Posts 64 Location https://bytes.com/topic/access/answers/569451-error-5922-when-opening-mailmerge-document-word 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 Was Unable To Open The Data Source Excel Reply With Quote 02-21-2014,02:18 AM #5 macropod View Profile View Forum Posts View Blog Entries View Articles VBAX Guru Joined Jul 2008 Posts 2,695 Location Cross-posted at: http://www.mrexcel.com/forum/newrepl...3128&noquote=1 For cross-posting etiquette, Word Was Unable To Open The Data Source 2016 I've got it working like this: Sub MailMerge() Dim SourceDoc As String '...
Word is very finicky about the SQL syntax used when connecting data in the field. 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 How can I build a board to mount climbing holds in my house? This way if programming woun't work, the mai merged can still be built manually using the save Excel file.. 0 LVL 74 Overall: Level 74 MS Access 72 MS Office Word 2013 Mail Merge Unable To Open Data Source
Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We It's supposed to replace its predecessor CONCATENATE. Get 1:1 Help Now Advertise Here Enjoyed your answer? Join our community for more solutions or to ask questions.
Note, also, that Word 2002 has real problems with updating links to databases connected using OLEDB. Word 2013 Word Was Unable To Open The Datasource Can I convert SVG text to path but reuse glyphs? To use this feature for other documents there are two steps involved, 1.
See how far you can get with the above guidance, and then post back any questions or your working code.
Reply With Quote 02-24-2014,08:43 AM #18 Frosty View Profile View Forum Posts View Blog Entries View Articles VBAX Master Joined Feb 2011 Posts 1,475 Location Oh, jeez... and do you actually want the ability to select multiple source files and perform the mail merge on them? Nov 27 '06 #2 reply P: 3 Willis Wilson Willis, Could you please post the Error Message and perhaps repost the code in the code tags formatted as it would be Word Was Unable To Open The Data Source Mail Merge Access Name:="H:\Jonathon Hunter Hill\AirMaster\AirMaster V 0.9.xlsm", '...
Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free. Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name I'm trying to set up a mail merge from Excel to Word. Can you check Help for the correct syntax?
with the parameter names and the passed values separated nicely ActiveDocument.MailMerge.OpenDataSource _ Name:=SourceDoc, _ ConfirmConversions:=True, _ ReadOnly:=False, LinkToSource:=True, _ AddToRecentFiles:=False, _ PasswordDocument:="", _ PasswordTemplate:="", _ WritePasswordDocument:="", _ WritePasswordTemplate:="", _ Revert:=False, _