Email using Outlook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Create a reference to the Outlook object model in tools-> references in the
VBE or use late binding.
 
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.
 
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.
 
Back
Top