View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
N10 N10 is offline
external usenet poster
 
Posts: 141
Default write email subject

HI Lynn

This works for me

ActiveWorkbook.SendMail ,Subject:="This is
IT!"

Best N10

"Lynn" wrote in message
ups.com...
Hi,
How do i write a marco to populate the email subject with "Here it is"
if i am sending email from excel?
thanks