Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / January 2007

Tip: Looking for answers? Try searching our database.

Problem with Outlook Automation

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Neil - 01 Jan 2007 02:58 GMT
I have some code I use to create a mail message in Outlook 2003 from Access
as follows:

Dim objOutlook As Outlook.Application
Set objOutlook = New Outlook.Application
etc....

The code works fine everywhere except on one computer. On that computer, the
user gets Error -2147024770: "Automation error. The specified module could
not be found." at the Set objOutlook line.

I did some searching online, and I found that most of the time when people
got that message, it was because a DLL wasn't registered. So I looked up the
reference (in Access 2003) to "Microsoft Outlook 11.0 Object Library," and
it referred to msoutl.olb. However, that OLB file can't be registered,
because it's not an OCX or DLL.

So, any thoughts about what needs to be done here?

Thanks!

Neil
Tom van Stiphout - 03 Jan 2007 03:54 GMT
Standard answer: spend a few more hours trying to find leads and
chasing them down. After that, it becomes cheaper to rebuild the
machine.  The first step in that direction should be to uninstall and
reinstall Outlook.

-Tom.

>I have some code I use to create a mail message in Outlook 2003 from Access
>as follows:
[quoted text clipped - 18 lines]
>
>Neil
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.