Hi Khelil

Look here
http://www.rondebruin.nl/sendmail.htm

My SendMail Add-in have this option also

--
Regards Ron de Bruin
http://www.rondebruin.nl


"kkhelil " wrote in message ...
I am looking for vba code to copyPaste a selected range of cells into
e-mail Body without creating a new workbook.

There is already a button into Excel tool bar who can perform this
function and I want to automate it through VBA code.

Thanks

Khelil

Attachment filename: send mail button.gif
Download attachment: http://www.excelforum.com/attachment.php?postid=627726
---
Message posted from http://www.ExcelForum.com/