How do you auto say yes to using outlook during excel macro

[Maui]

when using excel macro to create email I get a pop up box that says something like another application is trying to send mail, could be virus. How can you auto say yes to this.

 

[Andrew Fergus]

Hi
Have a look at the suggestions in this thread:
http://www.mrexcel.com/board2/viewtopic.php?t=229935
Andrew

 

[ndendrinos]

wongm003 gave this solution in a posting today and it works with OE and will test it on Lotus Notes later on today.

Private Sub Workbook_BeforeClose(Cancel As Boolean)

'save workbook
ActiveWorkbook.Save

If MsgBox("Submit for processing?", vbYesNo) = vbYes Then
'attach email and send to recipients...

'set recipients
arRecp = Array("111@sympatico.ca", "222@yahoo.com")

'set subject line
strSubj = "For your review"

'send email
ActiveWorkbook.SendMail Recipients:=arRecp, Subject:=strSubj

End If

End Sub


With OE the prompt is very similar to the one described here BUT without the mention of "viruses" .
I visited the link offered here and installed the free software and this did not eliminate this particular prompt.
Is the a solution to bypass this Outlook Express security measure?
Thank you
Nick

 

[ndendrinos]

Got the answer from Ron de Bruin's site
"Outlook Express


If you configure Outlook Express as the default mail handler (or simple MAPI client) on the

General tab, Outlook Express processes requests by using Simple MAPI calls.

Some viruses can exploit this functionality and spread by sending copies of e-mail messages

that contain the virus to your contacts.

By default, Outlook Express 6 prevents e-mail messages from being sent programmatically from

Outlook Express without your knowledge by displaying a dialog that enables you to send or not

send the message.

If you regularly use an application that uses Simple MAPI calls to send e-mail as yourself,

you may want to disable this protection as follows:


1 : Start Outlook Express, and then on the Tools menu, click Options.
2 : Click the Security tab, and then click to remove the check mark from the warn me when other

applications try to send mail as me check box.
3 : Click OK to close the Options dialog box.