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

i.e. I've to send hugh amount of reports out each day by running macro in Excel which always takes me 1 hour to d
at this moment, I can only wait to finish splitting reports, then go to Lotus and send those reports ou
I wanna to check if I can do it at the same time in one code, so that I can send one report out once it's ready

Thanks for hel