Send Worksheet in Email

I have a worksheet called Report that I want to send in an email
automatically when the workbook is opened and data is retrieved. the commmand
to send the worksheet will come after some other vb. THe email program we
use is Lotus Notes

Question. How do I program the worksheet to be sent using code and how would
I add a subject line and message as well as a send to address

Thanks

Hi Nigel

I can't help you with Lotus but my CDO code will work also
http://www.rondebruin.nl/cdo.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Nigel" <nigelben@belmontpines.com> wrote in message news:8DCE912B-C637-458F-9793-D277488D392A@microsoft.com...
>I have a worksheet called Report that I want to send in an email
> automatically when the workbook is opened and data is retrieved. the commmand
> to send the worksheet will come after some other vb. THe email program we
> use is Lotus Notes
>
> Question. How do I program the worksheet to be sent using code and how would
> I add a subject line and message as well as a send to address
>
> Thanks
>
>