Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

emailing from Access: "Outlook.Application" issue with Outlook object library

Posted on 2004-08-23
5
Medium Priority
?
786 Views
Last Modified: 2009-02-16
In my code, I specify the line to start my email task,

Set objOutlook = CreateObject("Outlook.Application")

I DID go to Tools, References, and checked "Microsoft Outlook 11.0 object library" (I have Outlook 2003)
But, when Access hits the above line, I get Automation error, the specified module could not be found.

what gives?
0
Comment
Question by:ToddRod_Taylor
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 39

Expert Comment

by:stevbe
ID: 11878691
if you are early binding a library (checking the reference box) then you should early bind in your code ...

Set objOutlook = New Outlook.Application

Steve
0
 

Author Comment

by:ToddRod_Taylor
ID: 12016245
I changed my code to early binding; and I still get the same error
0
 
LVL 39

Accepted Solution

by:
stevbe earned 300 total points
ID: 12017322
Do any of your references say "Missing"? If so, please clear that reference and recompile to see if you really need the "Missing" reference. As soon as 1 reference goes goofy functionality of all other libraries is compromised.
If you type Set objOutlook = New    and then a space does Outlook show in the intellisense dropdown?

Steve
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question