Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Emailing Excel? | Excel Discussion (Misc queries) | |||
Emailing Excel | Excel Discussion (Misc queries) | |||
Emailing with EXCEL | Excel Programming | |||
emailing from excel | Excel Programming | |||
Emailing from Excel | Excel Programming |