Thanks a million. This is super.
Steve
"Paul B" wrote in message
...
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" wrote in message
...
Hi
ActiveWorkbook.SendMail , 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