Microsoft Access can't send this e-mail message

[davesmith202]

I have my references now set to:

Microsoft DAO 3.6 Object library
Microsoft Outlook 11.0 Object library
Microsoft Office 11.0 Object library

I am running Outlook 2003.

However, I still get the same error message.

Dave

 

[mission2java_78]

Your code is wrong.

Redemption is not an object.

I dont know what you are trying to do...the solution I gave you is perfect I dont see why you cant use it.

 

[davesmith202]

Unfortunately, the solution you suggested still brings up the security window which I don't want. So I was looking at Outlook Redemption as a way to avoid this.

Dave

 

[mission2java_78]

Unfortunately, the solution you suggested still brings up the security window which I don't want. So I was looking at Outlook Redemption as a way to avoid this.

Dave

Is your comment making the code wrong?

Also you need to create an outlook object first before creating this.

 

[davesmith202]

Sorry, but my programming skills are a bit limited. I'm just under from understanding this. But your input has been really useful to me. Thanks for persisting!

Is my comment in which code? The Outlook Redemption stuff or earlier?

How do I create an Outlook object?

This forum could do with a samples section with lists of code. What do you think?

Thanks,

Dave

 

[dan-cat]

whose pinky..

He's the pink elephant that comes to visit me sometimes

Dave in response to your suggestion for a samples section - you'll find all the samples you need by using the search facility. A vast archive is all there waiting for you. To add to that archive here is an example of creating an outlook object


Public Sub SendEmailTest()
Dim db As Database
Dim objOutlook As New Outlook.Application
Dim objMessage As MailItem

Set db = CurrentDb()
Set objMessage = objOutlook.CreateItem(olMailItem)
With objMessage
.To = "somebody"somewhere.com"
.Subject = "New E-mail message"
.Body = "Type your email message here"
.Display
End With
End Sub

 

[davesmith202]

Thanks. That worked a treat and bypassed the security problem. I had this before but for some reason it came back. Very confusing.

Well, I am going to run with it because if it aint broke don't mess with it!

Thanks again.

Dave