Sending an email from access - without the security warning! 2

[policechiefwiggum]

Hi All,

Had a bit of a hunt around Google, and this seems to be a bit of a confusing one, i have the following code to send an email when a button is clicked -

DoCmd.SendObject acSendNoObject, , acFormatRTF, "xxxx@xxxx.com; yyyy@yyyy.com; zzzz@zzzz.com", Me.email.Value, , "UAT Roadmap Automated Contact - Password Reset", "This is an automated message from the UAT roadmap." & vbCrLf & vbCrLf & "User " & Me.Username.Value & " requires a password reset." & vbCrLf & "Contact Details are: " & Me.email.Value, False

when this code is executed i get a security warning, google says that i need a 3rd party app, or need to code my send command completely differently, as i've always had 1st class advice here i thought i'd pose the question here.

does anyone know if i can send an email without invoking the security warning?

Thanks
Policechiefwiggum

 

[HarleyQuinn]

You can use CDO. One example of which is in

http://www.tek-tips.com/viewthread.cfm?qid=1369407

Hope this helps

Andy
---------------------------------
[green]' Signature removed for testing purposes.[/green]

http://lessthandot.com

 

[PHV]

Replace this:
& Me.email.Value, False
with this:
& Me.email.Value, True

You may do a google search for outlook object model guard

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[policechiefwiggum]

WOW, Cheers guys, never ceases to amaze me at how quickly people reply here.

Really appriciate all the help i've got from these forums.