binod wrote:
Hi,

I am able to set up a macro to send an excel attachment through
msoutlook,
however is it possible to write a macro to copy a certain range of
data from excel (eg. A1:G10) and paste it as an object in in a new
mail msoutlook and send it as email.
Please help me on this one....

Take a look at http://www.rondebruin.nl/sendmail.htm
If you had put "excel send mail" into Google, it would have been the first
one on the list.