Sending a mail from Access to Outlook

  • Thread starter Thread starter Warrio
  • Start date Start date
W

Warrio

Hello!

I have a form in Access that sends mails through an Office Outlook profile.
DoCmd.SendObject , , , (e-mail address removed), , , "subject", "Text", False 'So
the email is sent without being displayed

This works perfectly, but Outlook displays an alert message saying:
"A program is trying to automatically send email on your behalf.
Do you want to allow this?
If this unexpected, it may be a virus and should choose No." [Yes] [No]

How can we avoid this message? so I can send my emails on one row.

Thanks for any suggestion
 
hi,
try this in the code
DoCmd.SetWarnings False
docmd.sendobject.....
Docmd.setWarnings True
regards
-----Original Message-----
Hello!

I have a form in Access that sends mails through an Office Outlook profile.
DoCmd.SendObject , , ,
Click to expand...
(e-mail address removed), , , "subject", "Text", False 'So
the email is sent without being displayed

This works perfectly, but Outlook displays an alert message saying:
"A program is trying to automatically send email on your behalf.
Do you want to allow this?
If this unexpected, it may be a virus and should choose No." [Yes] [No]

How can we avoid this message? so I can send my emails on one row.

Thanks for any suggestion


.
Click to expand...
 
It doesn't work..

the message is displayed by Outlook not from Access
maybe there is an option that I don't see and can be disabled to shut down
this security...


hi,
try this in the code
DoCmd.SetWarnings False
docmd.sendobject.....
Docmd.setWarnings True
regards
-----Original Message-----
Hello!

I have a form in Access that sends mails through an Office Outlook profile.
DoCmd.SendObject , , ,
Click to expand...
(e-mail address removed), , , "subject", "Text", False 'So
the email is sent without being displayed

This works perfectly, but Outlook displays an alert message saying:
"A program is trying to automatically send email on your behalf.
Do you want to allow this?
If this unexpected, it may be a virus and should choose No." [Yes] [No]

How can we avoid this message? so I can send my emails on one row.

Thanks for any suggestion


.
Click to expand...
Click to expand...
 
Back
Top