email macro

A

Alannah Schuman

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
 
A

Alannah Schuman

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
 
A

Alannah Schuman

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