E-mail from Excel
 

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

E-mail from Excel
 

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

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

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Dean" wrote:

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

E-mail from Excel
 

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

"ryguy7272" wrote:

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

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

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Dean" wrote:

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

E-mail from Excel
 

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

Thanks though.
Dean

"Dean" wrote:

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

"ryguy7272" wrote:

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

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

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Dean" wrote:

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