Removing the 'Deny' option when sending emails via Code

[nouveauricheinvestments]

Hi,

I am using the docmd.sendobject method to automatically generate an
email using the User's outlook and then send it with an attachment. I
am also using docmd.setwarning False and docmd.setwarnings True before
and after I send the object, respectively. However, the user still is
asked to 'Allow' the code to send the email. Is there anyway around
this? The email is sent to some degree as a security feature and I
would rather not leave it to user discretion to allow or deny the
sending of the email.

 

[Beetle]

The message you are seeing is actually a security feature of
MS Outlook, not Access, and from what I've read it is rather
complicated and difficult to get around (if it can be one at all).

 

[Daniel Pineault]

There are methods. Take a look at

http://www.dimastr.com/redemption/
http://www.slipstick.com/outlook/esecup.htm#autosec
http://www.granite.ab.ca/access/email/outlook.htm

Personally, I have found that using CDO is a very good approach for
bypassing this problem!
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[nouveauricheinvestments]

There are methods. Take a look at

http://www.dimastr.com/redemption/h...://www.granite.ab.ca/access/email/outlook.htm

Personally, I have found that using CDO is a very good approach for
bypassing this problem!
--
Hope this helps,

Daniel Pineaulthttp://www.cardaconsultants.com/
For Access Tips and Examples:http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

Okay Thank you very much for the info...I will read up on it...I
figured it was probably a security feature of outlook but I wasn't
sure...