Home > Unable To > Word Was Unable To Open The Data Source Excel

Word Was Unable To Open The Data Source Excel

Contents

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 Prepare your document for a table of contents (he… MS Word Select Case Automation: Taking the Pain out of Creating Select Case for Enumerated Lists Article by: DrTribos A few years 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. I needed to change trainer to Trainer in the above SQL statement. check over here

You may have to register before you can post: click the register link above to proceed. Any ideas would be greatly appreciated. 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. Were the Smurfs the first to smurf their smurfs? 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

Why don't you try something like this, just to test that functionality... I just need the mail merge to work!! 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)

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 with the parameter names and the passed values separated nicely ActiveDocument.MailMerge.OpenDataSource _ Name:="H:\Jonathon Hunter Hill\AirMaster\AirMaster V 0.9.xlsm", _ ConfirmConversions:=True, _ SQLStatement:="SELECT * FROM `MailMerge`" 'ReadOnly:=False, _ 'LinkToSource:=True, _ 'AddToRecentFiles:=False, _ 'PasswordDocument:="", Just click the sign up button to choose a username and then you can ask your own questions on the forum. Word Was Unable To Open The Data Source Word 2010 Privacy Policy Site Map Support Terms of Use MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions Members Articles Videos Courses Contribute Products BackProducts Gigs Live Courses Vendor Services Groups

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. Word Was Unable To Open The Data Source 2013 Because the usage is really really simple. 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 https://support.microsoft.com/en-us/kb/833064 Andyandy Friday, October 29, 2010 5:12 PM Reply | Quote 0 Sign in to vote HI Cindy.

Of course your own variable named "SelectedItems" is going to be blank... Word Was Unable To Open The Data Source Mac Be glad to attach the database if anyone needs it? Option Explicit Public Sub PrintMemberList() 'declare variables and assign addresses Dim strList As String, docMember As Powered by Blogger. So that I could use it in my side to reproduce this issue.

  • Privacy Policy Terms and Rules Help Popular Sections Word Outlook Excel Access Connect With Us Log-in Register Contact Us Forum software by XenForo™ ©2010-2014 XenForo Ltd.
  • Where to place the Error handler and what type of Error Handler? 9 17 6d Outlook is doing a little too much to an .ics email attachment - can I stop
  • Share a link to this question via email, Google+, Twitter, or Facebook.
  • Take it out of the AutoNew routine, and try stepping through the code...
  • Copyright 2004 - VBA Express 418,710 Members | 1,278 Online Join Now login Ask Question Home Questions Articles Browse Topics Latest Top Members FAQ home > topics >
  • 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.
  • For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184 - Frosty Reply With Quote 02-20-2014,11:40 AM #4 Frosty View Profile View Forum Posts View Blog Entries View Articles VBAX Master Joined Feb 2011 Posts
  • Word is very finicky about the SQL syntax used when connecting data in the field.
  • In order to force an ODBC connection, you need to click the "Show All" checkbox in the Confirm Data Source dialog box, then choose the appropriate ODBC driver from the list.

Word Was Unable To Open The Data Source 2013

and set the new variable to the result of fGetFilePath... https://bytes.com/topic/access/answers/569451-error-5922-when-opening-mailmerge-document-word It takes just 2 minutes to sign up (and it's free!). Word Was Unable To Open The Data Source Excel Set before 'Ali... 4 years ago Simple template. Word Was Unable To Open The Data Source 2016 Best regards, Bessie Zhao - MSFT MSDN Subscriber Support in Forum If you have any feedback of our support, please contact [email protected] remember to mark the replies as answers if they

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) check my blog 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 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, It could not better. Word 2013 Mail Merge Unable To Open Data Source

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 It connects to a SQL2005 via an ODBC connection that is configured to use NT authentication. Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More... http://techkumar.com/unable-to/unable-to-activate-windows-xp.html 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

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 Word 2013 Word Was Unable To Open The Datasource 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... Question is, however, if you really want to continue using ODBC, or whether you should switch to OLE DB (the default since Word 2003).

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.

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, In the mean time, we can wait and see if any other Experts chime in. 0 Message Author Comment by:zachvaldez2011-02-10 I check the links but litle work in access 2010 I had to use a loop to get it working, but it's pretty much perfect now. Word Was Unable To Open The Data Source Mail Merge Access We answer questions for free.

Mary Guest When I created a Macro to insert data from Access XP to Word XP, it works. We will be more than happy to be of assistance. CONTINUE READING Join & Write a Comment Already a member? have a peek at these guys with the parameter names and the passed values separated nicely ActiveDocument.MailMerge.OpenDataSource _ Name:=SelectedItems(1), _ ConfirmConversions:=False, _ ReadOnly:=False, _ LinkToSource:=True, _ AddToRecentFiles:=False, _ Revert:=False, _ Format:=wdOpenFormatAuto, _ SQLStatement:="SELECT * FROM `MailMerge`", _

Similar Threads Word was unable to open the data source Todd, Sep 26, 2003, in forum: Word Mail Merge Replies: 3 Views: 1,010 Peter Jamieson Sep 28, 2003 Word was unable