Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dave_2k5
 
Posts: n/a
Default 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   Report Post  
Ron de Bruin
 
Posts: n/a
Default

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   Report Post  
Dave_2k5
 
Posts: n/a
Default


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   Report Post  
Ron de Bruin
 
Posts: n/a
Default

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   Report Post  
Dave_2k5
 
Posts: n/a
Default


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   Report Post  
Ron de Bruin
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
I can not email excel files newbe New Users to Excel 3 March 10th 05 05:09 PM
how to turn off email header with excel workbook larhere Excel Discussion (Misc queries) 0 January 5th 05 01:39 AM
Email from inside excel Kelly Thompson Setting up and Configuration of Excel 1 December 16th 04 10:22 PM


All times are GMT +1. The time now is 06:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"