how do i send email from a macro

[dok112]

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

 

[Tom Ogilvy]

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

 

[dok112]

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

 

[Tom Ogilvy]

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-us/odc_xl2003_ta/html/odc_xlmail.asp