Hi All,
does any know how to set an active range as email subject?
case like i may select certain cell or range and want it send out as email subject.
ActiveWorkbook.EnvelopeVisible = True
With ActiveSheet.MailEnvelope
.Introduction = ""
.Item.to = ""
.Item.Subject = ""
.Item.Send
End With
does any know how to set an active range as email subject?
case like i may select certain cell or range and want it send out as email subject.
ActiveWorkbook.EnvelopeVisible = True
With ActiveSheet.MailEnvelope
.Introduction = ""
.Item.to = ""
.Item.Subject = ""
.Item.Send
End With