Word Error 5922
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 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 Solved Error 5922 Posted on 2011-02-07 MS Access MS Word MS Office 1 Verified Solution 10 Comments 932 Views Last Modified: 2012-05-11 I have a mailmerge between access and word bu It's really hard to scan through code without any of the visual symbols included in normal code formatting (indentation etc). useful reference
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) = SourceDoc Else Exit Sub End I will try what you suggest. Can you check Help for the correct syntax? Becuse youve switched the core way your code was working, from the end-user perspective (allowing multi-select vs not allowing) Reply With Quote Page 1 of 5 1 2 3 ... 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
The only problem I have is that it takes about 30 seconds to work, so if you have any hints as to why that might be, I'd appreciate them. here's the connection.. End Sub Formatting tags added by mark007 But it's not acceptable for me to have the source in there, as I've said.
How loop many pictures into tex document? It had a .tmp extension because the facility in the .net framework that generates and returns a temporary filename puts it there. Frosty, thank you very much. Word Was Unable To Open The Data Source Word 2010 Office / Productivity MS Office Office Suites-Other MS Word Using SmartArt to Create Charts Video by: Tony The viewer will learn how to make their project stand out over others by
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, Word Was Unable To Open The Data Source 2013 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 Visual Basic short-circuit evaluation of expressio... ► October (3) ► September (2) ► August (5) ► July (2) ► June (8) ► May (12) ► April (6) ► March (1) ► However, this article shows that the latest Office 2016 apps (installed with an Office … Office 365 MS Office Office / Productivity Document Imaging Document Management Introducing CONCATENATE's successor: CONCAT Article
Mary Guest When I created a Macro to insert data from Access XP to Word XP, it works. Word Was Unable To Open The Data Source Mac Cause this is pressing, I end up doing the following Run the query and stored it in excel file for excample strsql= "Select * INTO from table" then I did Docmd.Transfer... You'll also need to modify the filter back to the way you want it to be. Originally Posted by macropod As for: there's not much point in defining and selecting a source document, then not using it!
- Dec 10 '06 #4 reply P: 3 Willis Wilson I don't know the correct syntax for this command, but I would guess the Connection parameter is wrong.
- However, it then allows me to select a document (which I am able to mail merge manually), and then I can select the Provider (OLED), despite that choice already being filled
- All rights reserved.
- 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
- Here's the thing...
- Error 5922 when opening a mailmerge document in Word P: 3 Willis Wilson Platform: Access 2003 SP2 and Windows XP.
- Advertisements Latest Threads How to create bulleted to-do list using two styles?
- Last Jump to page: Quick Navigation Word Help Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Announcements Announcements Introductions VBA Code & Other Help How
Word Was Unable To Open The Data Source 2013
Try modifying just the function above and seeing if your message box result continues to be an empty string, or if it is actually representative of the path you want. https://bytes.com/topic/access/answers/569451-error-5922-when-opening-mailmerge-document-word 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 Word Was Unable To Open The Data Source Excel 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. Word Was Unable To Open The Data Source 2016 Login.
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) It's quick & easy. Software Salariman Nuts and bolts about programming applications, databases and spreadsheets. It had a .tmp extension because the facility in the .net framework that generates and returns a temporary filename puts it there. Word 2013 Mail Merge Unable To Open Data Source
what you want is the .SelectedItems array which is a property OF the dialog picker... I don't have access to a coding box here... This can't be avoided, due to the nature of how the program will be used. So that I could use it in my side to reproduce this issue.
and set the new variable to the result of fGetFilePath... Word 2013 Word Was Unable To Open The Datasource 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 And what's new?
and do you actually want the ability to select multiple source files and perform the mail merge on them?
And thanks for the extra tip. with the parameter names and the passed values separated nicely ActiveDocument.MailMerge.OpenDataSource _ Name:=.SelectedItems(lngCount), _ ConfirmConversions:=True, _ ReadOnly:=False, _ LinkToSource:=True, _ AddToRecentFiles:=False, _ Revert:=False, _ Format:=wdOpenFormatAuto, _ SQLStatement:="SELECT * FROM `MailMerge`", _ Is there a name for the (anti- ) pattern of passing parameters that will only be used several levels deep in the call chain? Word Was Unable To Open The Data Source Mail Merge Access Check the links I posted, and see if any of them are applicable.
Sometimes I forget to check the box when creating a post to send an email when there is activity. Dev Center Explore Why Office? Join our community for more solutions or to ask questions. It's supposed to replace its predecessor CONCATENATE.
Your name or email address: Do you already have an account? Here is what I found. 1. Is there a technical term for this simple method of smoothing out a signal? and my demo code shows the usage of.
This can't be avoided, due to the nature of how the program will be used. Analytic Geomtry Proof Involving Triangles, Midpoints, and Perpendicular Lines How is the numbering in phenylpropenes? more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed I get runtime error 4198.
I'm not fixed on how to do the file picking bit, so if you have any other suggestions then please do let me know. and seeing if your connection string is wrong (almost guaranteed) or some other parameter you're passing. 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 It takes just 2 minutes to sign up (and it's free!).
The actual filename of the Access database and its extension should not matter. Have a nice day. Suggested Solutions Title # Comments Views Activity Google Chrome Will No Longer Spell Check 7 53 138d Blogging: looking for handful of blogging best practices 3 70 127d font type, point 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.
Get 1:1 Help Now Advertise Here Enjoyed your answer? Andy andy Marked as answer by andy pelkey Friday, October 29, 2010 6:15 PM Friday, October 29, 2010 6:14 PM Reply | Quote All replies 0 Sign in to vote You