How to bypass security warning message when trying to sendmail in excel

T

topalps

hi,

I'm working on vba in excel and what I am trying to do is send the
workbook working on to somebody according to a mail list. Cause the
process is very time-consuming, it would be run at night. I have tried
several ways: sendmail method, mailenvelope property and routingslip
object. but a security warning pop-up message box from outlook always
showed itself. the mail can't send automatically. what can I do to
bypass this warning message.

thanks
 
D

dolivastro

You really can't bypass this warning. Or, if you find a way, then you
have found a bug. What you are doing is a security violation. If it
could be done, think of how easy it would be to send out viruses and
worms.

Dom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top