Some years ago I was assisted by your site with the following VBA code which splits off excel worksheets and emails it to the email contained in cells K1:k2. This has been working for me for years perfectly! And an incredible time saver!
Sub EmailReport()
'copy each sheet into a new workbook
'and email it to the address in cells K1:K2
For i = 1 To Sheets.Count
Sheets(i).Select
Sheets(i).Copy
ActiveWorkbook.SendMail Recipients:=Range("K1:K2").Value, Subject:="DAILY STATUS REPORT"
ActiveWindow.Close SaveChanges:=False
Next
End Sub
Private Sub Workbook_Open()
End Sub
My question is: Can I add narrative to the body of the outgoing email?
It's awesome that I can adjust the Subject Line of the email. I've been using the subject line to contain anything I wish to convey to the recipient. As an example: "Daily Status Report. February results for your review and approval. Please reply by Friday, March 29, 2024."
This sometimes makes for a very long subject line. I was wondering if I could just update the code in some way so that this information actually goes into the body of the email instead of on the subject line?
Bookmarks