E-mail from Excel

[Dean]

I want to use Excel to email forms. However I want to stop the users
altering certain details like the To: address and the subject etc.
Is it possible either in Excel or VBA and if so how?

Thanks in advance.

Dean

 

[ryguy7272]

Take a look at this:
http://www.rondebruin.nl/sendmail.htm

If you are still struggling, post back with specific questions.

 

[John Bundy]

Ron has everything under the sun dealing with emailing from excel on his site:
http://www.rondebruin.nl

 

[Dean]

Ryan,

This info could be useful but I don't see what I'm after.
When using Excel 2003 and the e-mail function in it. I have set up a form
for users to fill in I then want them to just press the "Send" button.
Currently the TO: e-mail address and subject lines are filled in for them and
I don't want the users to be able to change them. Is it possible to grey
these fields out and if so how?

Thanks

 

[Dean]

Ignore me. I've gone for the Outlook sending the mail process wich seams to
be working.

Thanks though.
Dean