Your code rocks!
Thanks,
--
EddieV


"Ron de Bruin" wrote:

Hi Canlink

Try this example if you use Outlook
http://www.rondebruin.nl/mail/folder3/mail4.htm

Or
http://support.microsoft.com/default...b;en-us;816644


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Canlink" wrote in message ...
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?