Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sendinf Email From Excel
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 -- Dave_2k5 ------------------------------------------------------------------------ Dave_2k5's Profile: http://www.excelforum.com/member.php...o&userid=19667 View this thread: http://www.excelforum.com/showthread...hreadid=389836 |
#2
|
|||
|
|||
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 -- Dave_2k5 ------------------------------------------------------------------------ Dave_2k5's Profile: http://www.excelforum.com/member.php...o&userid=19667 View this thread: http://www.excelforum.com/showthread...hreadid=389836 |
#3
|
|||
|
|||
I have looked at the suggested site and these solutions all involve installng 3rd party software or work with entering SMTP details. As I am send the survey out to 100 people, I cann't get them to install the program. The poeple I am sending this to are on different exchange servers, so I cannot use the SMTP details. Any other suggestions? Dave -- Dave_2k5 ------------------------------------------------------------------------ Dave_2k5's Profile: http://www.excelforum.com/member.php...o&userid=19667 View this thread: http://www.excelforum.com/showthread...hreadid=389836 |
#4
|
|||
|
|||
Hi Dave
Do all users use Outlook ? -- Regards Ron de Bruin http://www.rondebruin.nl "Dave_2k5" wrote in message ... I have looked at the suggested site and these solutions all involve installng 3rd party software or work with entering SMTP details. As I am send the survey out to 100 people, I cann't get them to install the program. The poeple I am sending this to are on different exchange servers, so I cannot use the SMTP details. Any other suggestions? Dave -- Dave_2k5 ------------------------------------------------------------------------ Dave_2k5's Profile: http://www.excelforum.com/member.php...o&userid=19667 View this thread: http://www.excelforum.com/showthread...hreadid=389836 |
#5
|
|||
|
|||
Yes all the users use Outlook -- Dave_2k5 ------------------------------------------------------------------------ Dave_2k5's Profile: http://www.excelforum.com/member.php...o&userid=19667 View this thread: http://www.excelforum.com/showthread...hreadid=389836 |
#6
|
|||
|
|||
Hi Dave
You can use the Outlook object model See my site for examples http://www.rondebruin.nl/sendmail.htm Use Late Binding (example on each Outlook page) Then you can use .Display instead of .Send so the user must press the Send Button. You can press the button automatic with SendKeys But it is possible that this is not working for all your users Application.SendKeys "%S" Check out also this webpage (best option if you can use it) http://www.rondebruin.nl/cdo.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Dave_2k5" wrote in message ... Yes all the users use Outlook -- Dave_2k5 ------------------------------------------------------------------------ Dave_2k5's Profile: http://www.excelforum.com/member.php...o&userid=19667 View this thread: http://www.excelforum.com/showthread...hreadid=389836 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
I can not email excel files | New Users to Excel | |||
how to turn off email header with excel workbook | Excel Discussion (Misc queries) | |||
Email from inside excel | Setting up and Configuration of Excel |