Email using Outlook

[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)

 

[Tom Ogilvy]

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

 

[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.

 

[Tom Ogilvy]

Yes. Look down the list until you find Microsoft Outlook and tick that.

 

[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.