How to email report automatically?

[Megan]

Hi, I have set up a macro to email a report, but everytime the macro runs, my
email program (lotus notes) opens and I will need to click 'send' to send the
report. I already set the 'Edit message' to No, but i still need to go thru
my lotus notes to finish the 'send' job.

I need to email this report every day, and I will be away from work for a
week. So, does anyone know how to automatically email a report without the
need to click the 'send' button in lotus notes? please helps.... :-(

Thanks in advance