how to email sheets

A

Andy T

Hi all,

I've written a program that uses OLE to call excel and it creates a
workbook with lots of sheets. Each sheet has an email address on it
to where it needs to be sent to via Outlook.

I would like to know how to email each individual page to that
individual email. I thought maybe I would at least save each page
into a separate file ? or is there a way I can use a macro or
something to automatically send the emails.

Thanks in advance

Andy
 
Top