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....


--
binod
------------------------------------------------------------------------
binod's Profile: http://www.excelforum.com/member.php...o&userid=34985
View this thread: http://www.excelforum.com/showthread...hreadid=547248

Hi Binod,

See Ron de Bruin at:

http://www.rondebruin.nl/mail/folder2/mail4.htm


---
Regards,
Norman



"binod" wrote in
message ...

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....


--
binod
------------------------------------------------------------------------
binod's Profile:
http://www.excelforum.com/member.php...o&userid=34985
View this thread: http://www.excelforum.com/showthread...hreadid=547248

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.

Thanks for the link, I am trying it now,and am now not able to add a
reference to the Microsoft outlook Library to get the macro working.


--
binod
------------------------------------------------------------------------
binod's Profile: http://www.excelforum.com/member.php...o&userid=34985
View this thread: http://www.excelforum.com/showthread...hreadid=547248

Hi Binod,

Thanks for the link, I am trying it now,and am now not able to add a
reference to the Microsoft outlook Library to get the macro working.


With the project active in the VBE, try:

Tools | References | scroll to and select:

Microsoft Outlook xx.x Object Library


---
Regards,
Norman