emailing using Excel VBA

[SP]

Hi

ActiveWorkbook.SendMail Recipients:[email protected], Subject:="test
excel email"

I'm using the above code to send a workbook as an attachment. As the code
is executed, an OE prompt pops up saying
"A program is attempting to send the following e-mail message on your
behalf:
...
Would you like to send the message ?"

Is it possible to disable this message ?

Thanks
Steve

 

[Paul B]

Steve, have a look here at Ron de Bruin's site for how to do it,
http://www.rondebruin.nl/mail/prevent.htm and click on the index at the top
of the page to find out MUCH more on sending mail

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[SP]

Thanks a million. This is super.
Steve

Steve, have a look here at Ron de Bruin's site for how to do it,
http://www.rondebruin.nl/mail/prevent.htm and click on the index at the
top
of the page to find out MUCH more on sending mail

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003