Macro for excel & msoutlook

[binod]

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

 

[Norman Jones]

Hi Binod,

See Ron de Bruin at:

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

 

[Paul Lautman]

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.

 

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

 

[Norman Jones]

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

 

[binod]

Thanks Norman & Paul for your help... i am now able to send mail as
object through excel, I had not checked the Outlook object library in
tools.