email macro
 

Hi

I want to create a macro that will mail a range of cells in the body of an
email, I use Outlook express, is this possible?

Thanks in advance
Alannah

email macro
 

Se Ron's pages:
http://www.rondebruin.nl/sendmail.htm

"Alannah Schuman" <Alannah Schuman @discussions.microsoft.com wrote in
message ...
Hi

I want to create a macro that will mail a range of cells in the body of an
email, I use Outlook express, is this possible?

Thanks in advance
Alannah

email macro
 

Thanks Cory

I have tried Ron's code but met error '429' Activex component-- can't create
object.

The problem in the vb code is 'Set OutApp =
CreateObject("Outlook.Application")'. Thats why i thought using Outlook
Express might be a problem. Do you know anything about this?

Thanks
Alannah

email macro
 

Did you see this:
http://www.rondebruin.nl/mail/oebody.htm

Corey....
"Alannah Schuman" wrote in
message ...
Thanks Cory

I have tried Ron's code but met error '429' Activex component-- can't
create
object.

The problem in the vb code is 'Set OutApp =
CreateObject("Outlook.Application")'. Thats why i thought using Outlook
Express might be a problem. Do you know anything about this?

Thanks
Alannah

email macro
 

Thanks Corey i had missed that bit. i have now made some code using send keys
that works!

"Corey" wrote:

Did you see this:
http://www.rondebruin.nl/mail/oebody.htm

Corey....
"Alannah Schuman" wrote in
message ...
Thanks Cory

I have tried Ron's code but met error '429' Activex component-- can't
create
object.

The problem in the vb code is 'Set OutApp =
CreateObject("Outlook.Application")'. Thats why i thought using Outlook
Express might be a problem. Do you know anything about this?

Thanks
Alannah