I was wondering if it is possible to set-up an automatic e-mail of a file or
at least Run a macro within a file that generates an e-mail. I've used code
from Ron De Bruins excellent inf on e-mailing but can't see anything
specific on this area.

Basically I have an Excel file which I generate an e-mail from (via macro) I
need to send this out every weekend, so to save me working 7 days a week, I
was wondering if there is any code that will open my file, "click" a macro
that will generate my Report then "click" another Macro that will e-mail
this Report out.

I have both the "Generate Report" and "Mail Report" set up and working, but
I need to automate the actual "clicking" of these macros, say every Saturday
and Sunday at 10:00am

Thanks