Hi Guys!
I looked everywhere and couldn't find the answer I was looking for.
I need to create a macro which will send an e-mail from excel sheet.
The subject should contain pre-determined text, the current date and values(numbers) from two cells.
The body should have a header(range A2:L2) and a data I select from a specific row.
Here's the code I have so far. I can't see how to include the headers in the introduction filed as fixed range and add the selection below:
"
Sub Send_Range()
ActiveSheet.Range("A2:L2").Select
ActiveWorkbook.EnvelopeVisible = True
With ActiveSheet.MailEnvelope
.Introduction = "Dear Team,Please see the below payment request:"
.Item.To = "My@Email.com"
.Item.Subject = "Payment Request " & Date
End With
End Sub
"
I hope I'm clear...
Thanks!
I looked everywhere and couldn't find the answer I was looking for.
I need to create a macro which will send an e-mail from excel sheet.
The subject should contain pre-determined text, the current date and values(numbers) from two cells.
The body should have a header(range A2:L2) and a data I select from a specific row.
Here's the code I have so far. I can't see how to include the headers in the introduction filed as fixed range and add the selection below:
"
Sub Send_Range()
ActiveSheet.Range("A2:L2").Select
ActiveWorkbook.EnvelopeVisible = True
With ActiveSheet.MailEnvelope
.Introduction = "Dear Team,Please see the below payment request:"
.Item.To = "My@Email.com"
.Item.Subject = "Payment Request " & Date
End With
End Sub
"
I hope I'm clear...
Thanks!
