Solved

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

Posted on 2004-08-23
5
785 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 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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

617 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