Sending E-mails

[damian]

I've used VBA (got the code off this forum) to e-mail the results of a query to a colleague. The problem I have is where a window appears displaying the following:

"A program is trying to send mail using Item.Send
A program is trying to automatically send e-mail using a Microsoft Outlook Visual Basic Application command, Item.Send. If you want this program to send this e-mail, click Yes. To stop the program, click No. If you are unsure which program is sending the e-mail or why, you may want to click No to avoid any possible spread of viruses.

Note When this message is displayed, the Yes button is not available for 5 seconds."

Is there any way of avoiding having to acknowledge this message???

 

[ReAn]

This should do it.

DoCmd.SetWarnings False

'Your code here

DoCmd.SetWarnings True

 

[Mile-O]

Is there any way of avoiding having to acknowledge this message?

The SetWarnings method won't work here. It's part of Microsoft's enhanced software security to stop malicious code.

This product (Outlook Redemption) will remove it.

 

[damian]

Thanks for the suggestions so far.

I'm not prepared to use the Outlook Redemption programme as it may have further implications for the network at my workplace.

Are there any other options???