send email without Outlook asking to allow?

[Guest]

I would like to use SendObject to send an email to me when a user clicks
"Submit" on a particular form. The code below works, but the user gets a
pop-up from Microsoft Office Outlook: "A program is trying to automatically
send e-mail on your behalf. Do you want to allow this?". The user has to
click "Yes", "No" or "Help".

This would probably alarm the user or at the very least be considered an
annoyance. Is there any way to send an email without triggering the Outlook
pop-up?

Private Sub cmdSubmit_Click()
DoCmd.SendObject , , , "(e-mail address removed)", , , "A DSSF has been
submitted.", "Body goes here.", False
End Sub

Thank you for any help you can give me,
Judy

 

[Guest]

There is a good reason for the security pop-up! To stop the automated
propagation of virii.

As for a solution, there are way to get aroud it.
1- Install a program such as clickyes to automatically press the yes button
2- Use CDO to send your emails.

In any case here are a few website with info on this issue
http://www.slipstick.com/outlook/esecup.htm - specifically the "Automation
Security" and outlook redemption
http://www.contextmagic.com/express-clickyes/

 

[Guest]

Daniel,

Thank you for responding. I was hoping for a solution that I could use that
would not involve having the users install anything or change any of their
settings (since they are going to get the pop-up when they click the submit
button, not me).

I know that we have a vb script that sends email without having an issue
with this pop-up. I guess I'll have to call the vb script instead.

Thanks again,
Judy