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/