Email using Outlook

P

Paul Dennis

I have set up an excel book that when a button is pressed it auto emails the
saved book via Lotus Notes. I now need to do the same but via Outlook. I have
used the code associated with SendWithOutlook but I get an error message
straight off, on the line Dim objOL As New Outlook.Application. The error is
"Compile error: User-defined type not defined".

any ideas?

Sub SendWithOutlook()

Dim objOL As New Outlook.Application
Dim objMail As MailItem
Set objOL = New Outlook.Application
Set objMail = objOL.CreateItem(olMailItem)
 
T

Tom Ogilvy

Create a reference to the Outlook object model in tools-> references in the
VBE or use late binding.
 
P

Paul Dennis

How do I make a reference? Is it a matter of ticking one of the options? if
so which one? You can guess I'm a novice at this.
 
G

GK

Hello,

I have the same problem, when I follow the suggestion at my MS Access,
Tool-reference, I am not able to locate "reference' menu item. I am using MS
Access 200 3 and Outlook 2003.

thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top