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