how to email sheets

[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

 

[Jason Morin]

MVP Ron de Bruin has some code on his site that may be
useful to you:

http://www.rondebruin.nl/sendmail.htm

HTH
Jason
Atlanta, GA