View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default write email subject

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?