Ok,

So I have part of my macro, and I need for it to create a new emai
being sent to me when the tab is clicked. I don't want it to send i
to me automatically. It's going to be a Comment/Suggestion email tha
I need to implement on my userform. I've tried everything I can fin
here and several other websites, but it all pertains to sendin
workbooks/sheets automatically. Not the way I need it

--
Message posted from http://www.ExcelForum.com

It sounds like you have the code you need. Just tie the code to the Click
event of the button on the userform.

--
Regards,
Tom Ogilvy

"dok112 " wrote in message
...
Ok,

So I have part of my macro, and I need for it to create a new email
being sent to me when the tab is clicked. I don't want it to send it
to me automatically. It's going to be a Comment/Suggestion email that
I need to implement on my userform. I've tried everything I can find
here and several other websites, but it all pertains to sending
workbooks/sheets automatically. Not the way I need it.


---
Message posted from http://www.ExcelForum.com/

Ok, the only problem, is I don't know how to write the code. All th
codes that I have found, creates the email and automatically sends it
and creates attachments. I just need to find out how to create a ne
email and update the To field and the Subject field

--
Message posted from http://www.ExcelForum.com

that is what sendmail does. What do you want to do. Do you want to write
information in the email and send it but not add an attachment. Anyway, Ron
de Bruind covers all types of options using SendMail, Outlook using
Automation and CDO. You should find code there that suits your needs:

http://www.rondebruin.nl/index.html

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


an Article by Ron on MSDN:
http://msdn.microsoft.com/library/en...odc_xlmail.asp

--
Regards,
Tom Ogilvy


"dok112 " wrote in message
...
Ok, the only problem, is I don't know how to write the code. All the
codes that I have found, creates the email and automatically sends it,
and creates attachments. I just need to find out how to create a new
email and update the To field and the Subject field.


---
Message posted from http://www.ExcelForum.com/