Using a value from a cell in an email subject line

[pryest]

My first question was how to have a macro email a document to a specific address. John was great to give me the code below to do this. One addition question I have is how can I pull a value from a Cell in the document to be included in the subject line of the email. Thanks

CODE
ActiveWorkbook.SendMail "Recipient@emailaddress.com", "Subject"

Mike

 

[PHV]

A starting point:
With ActiveWorkbook
.SendMail "Recipient@emailaddress.com", .Sheets("SheetName").Range("C7")
End With

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886