Solved

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

Posted on 2004-08-23
5
783 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
  • 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 75 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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
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…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

828 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