With SendMail the only way is not to fill in a e-mail address
.SendMail "", "This is the Subject line"
If you use the Outlook Object model you can use Display instead of Send
See the examples on my site
http://www.rondebruin.nl/sendmail.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"N10" wrote in message ...
Whats you existing code like?
N10
"Lynn" wrote in message oups.com...
ActiveWorkbook.SendMail will send the worksheet straight away.
I only need to input "This is IT" into the subject field.
any idea?