Stel wrote:
anyone knows if I can use macro to send out the reports by email through Lotus? If yes, how?


Take a look at
http://www.rondebruin.nl/sendmail.htm
which has a lot of options for sending mail from Excel, some of which shold work with Lotus
Notes.


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup