Send Mail - Outlook verification

[PolarBear]

I'm trying to use the SendMail function to email some sheets to team managers. The code works fine, but Outlook pops up a (very slow) msg box that says "A program is trying to send mail automatically on your behalf. Do you want to allow this?"

It's annoying.

I know this isn't strictely an excel question, but is there a way to turn off this verification in Outlook? I've gone through all the security options, but that doesn't seem to help.

 

[Zack Barresse]

Moved to the appropriate forum.

This is a security measure that Outlook has. You'll need to do something else for it. I recommend checking out one of these possibilities...

Outlook Redemption
ClickYes
CDO
Programmatically creating Outlook UDF to send*

HTH

* Check out this thread: http://www.tek-tips.com/viewthread.cfm?qid=1270370 for more info.

 

[Andrew Fergus]

Hi

Following on from firefytr I use 'Express Click Yes' and it works well.

Software here : http://www.contextmagic.com/express-clickyes/
Sample code here : http://www.tek-tips.com/faqs.cfm?fid=5230 but I think this is using different 'click yes' software to the one I linked.

HTH, Andrew

 

[awalle]

PolarBear,

Is there a simple way to avoid this, (well at least it works for me), if the list of users you want to use, is always the same, go to outlook and create a Distribution list, then use the following function to send the message:

Workbooks.Open Filename:= _
"C:\Testfile.txt"
ActiveWorkbook.SendMail Recipients:="Test_DList", Subject:="Testing Distribution list"
ActiveWorkbook.Close

The ugly part of this (always happens), is that you must open the file, within excel, you are trying to send, But at least you avoid the slow and annoying excel message A program is trying to send mail automatically on your behalf. Do you want to allow this?"

Hope this can help you.
AWalle

 

[Zack Barresse]

SendMail is an option, but it's not Outlook, rather Outlook Express.

 

[PolarBear]

Thanks everyone, I appreciate the suggestions. Now if I can get my sysadmin to allow me to install these programs...