View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Wilson John Wilson is offline
external usenet poster
 
Posts: 550
Default Putting the Subject field in SendMail

Michael,

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

For your specific question, here's an example:

ActiveWorkbook.SendMail ", _
Subject:="This is a test subject"

John

Michael wrote:

Help
I am using SendMail in a Macro and can get the address to
work but can not fill in the subject field. An example
would be most helpful.

Thanks