ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   SendMail Method (https://www.excelbanter.com/excel-programming/335417-sendmail-method.html)

Dave_2k5[_2_]

SendMail Method
 

I am buliding a questionnaire using Excel and I am using option button
and text boxs. I want to beable to send it via email with one butto
press. When I use the SendMail Method in the code of a button, when
press the buton it displays another dialog box confirm that you want t
send the email. Is there any way to get rid of the message box and fo
it just to send??

Cheers,

Dave :confused

--
Dave_2k
-----------------------------------------------------------------------
Dave_2k5's Profile: http://www.excelforum.com/member.php...fo&userid=1966
View this thread: http://www.excelforum.com/showthread.php?threadid=38983


Ron de Bruin

SendMail Method
 
See
http://www.rondebruin.nl/mail/prevent.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Dave_2k5" wrote in message
...

I am buliding a questionnaire using Excel and I am using option buttons
and text boxs. I want to beable to send it via email with one button
press. When I use the SendMail Method in the code of a button, when I
press the buton it displays another dialog box confirm that you want to
send the email. Is there any way to get rid of the message box and for
it just to send??

Cheers,

Dave :confused:


--
Dave_2k5
------------------------------------------------------------------------
Dave_2k5's Profile: http://www.excelforum.com/member.php...o&userid=19667
View this thread: http://www.excelforum.com/showthread...hreadid=389837





All times are GMT +1. The time now is 11:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com