emailing using Excel VBA
 

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

emailing using Excel VBA
 

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

emailing using Excel VBA
 

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