Sure
http://www.rondebruin.nl/sendmail.htm#Tips
--
Regards Ron de Bruin
http://www.rondebruin.nl
"RPIJG " wrote in message ...
Is this possible? I'm using this from Ron...
Code:
--------------------
Dim strDate As String
Sheets("Quote").Copy
strDate = Format(Date, "dd-mm-yy")
ActiveWorkbook.SaveAs "Your Synthetic Shield " & ThisWorkbook.Name _
& " " & strDate & ".xls"
ActiveWorkbook.SendMail "", _
"This is the Subject line"
ActiveWorkbook.ChangeFileAccess xlReadOnly
Kill ActiveWorkbook.FullName
ActiveWorkbook.Close False
--------------------
But I want the Subject line to be values from a range, is this
possible?
---
Message posted from http://www.ExcelForum.com/