Look at Ron's site. If you don't find the answer there, it probably is not
practical to do.

http://www.rondebruin.nl/sendmail.htm


"sam" wrote in message
...
Hi All, I have designed a button "Submit" on excel userform to email the
userform inputs to me.

What is happening is: Once I click "Submit" it opens the new
workbook(where
I am saving the userinputs) , saves it.. and them mails it.. and this is
working great!

What I want is: Is there a way I can do this process without the new
workbook opening? I dont want it to open, save and mail.. I just want it
to
save it and mail it..

Hope I made it clear

Thanks in Advance