I cannot find any VBA code to allow me to send a Selected Range as
part of the body of an email. I can do this easily by first selecting
the range; and the use MSExcel menu "File-Sent To-Mail Recipient" add
email address and subject and then press "Send-Selection".

I can send a whole workbook using VBA Code:- "ActiveWorkbook.SendMail"
but not a selected range.
Can anyone help?