Sendinf Email From Excel

[Dave_2k5]

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

 

[Ron de Bruin]

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

 

[Dave_2k5]

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

 

[Ron de Bruin]

Hi Dave

Do all users use Outlook ?

 

[Dave_2k5]

Yes all the users use Outloo

 

[Ron de Bruin]

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