Bypassing #@$^%#! Email Security

[Guest]

I have an application that uses the SendObject command to send emails. With
the new Outlook security I get the messagebox stating "A program is trying to
automatically send email on your behalf" and I have to click the "Yes" button
to confirm sending the email. The problem is that sometimes the application
will need to send the email automatically without someone being available to
click the "Yes" button. Anyone have any workarounds???

 

[Jeff Conrad]

Here is some info on this subject which should help.

From a past post by the angelic MVP Cheryl Fischer:Unless you are working in an Exchange environment, these prompts cannot be
turned off. If you are working in the Exchange environment see:
http://www.outlookcode.com/d/sec.htm

To work around this feature, I have been pleased with Express Soft's free
utility called "ClickYes", available for download at:
http://www.express-soft.com/mailmate/clickyes.html. It does not make the
security prompt go away, but it does use api calls to click the 'Yes' button
for you. Here is a link to a thread where you can find code that will check
to see whether ClickYes is running, start the utility, run email-related
code, and then turn the utility off. http://tinyurl.com/3x3xj

ClickYes is not the only work-around or option available; others can be
found at: http://www.outlookcode.com/d/sec.htm
And a post by someone named John Conklin:I found this on a website somewhere and just put it into my database, and it
works great.

Set outl = CreateObject("Outlook.Application")
Set mail = outl.CreateItem(olMailItem)
mail.To = "(e-mail address removed)"
mail.Subject = ActiveWorkbook.Name
mail.attachments.Add (ActiveWorkbook.FullName)
mail.display
SendKeys "^{ENTER}"

Set outl = Nothing
Set mail = Nothing
Hope that helps you,

 

[Paul Overway]

I liked that last one Jeff...cool.

 

[Paul Overway]

Awww...spoke to soon...I just noticed that last tip doesn't actually send
the item...it just displays it. So, you'd have to open the item manually
and send it. Otherwise, it just sits in your Outbox.

 

[Jeff Conrad]

Thanks for the info Paul.
I had never tried that technique; I had just saved the
post information a long time ago.