Automate a macro

[Guest]

I need to run a report every night and it is easiest to have as a html file,
and I need this emailing to a number of people every night, Is this possible.

I am presently using xp -home edition with Office 2003.
I have set up a macro to produce the report.

Can it be set to run every 24 hours?

can it be set to create email?

If so how.
I am not a numpty, but need step by step instructions

I would be most grateful if anyone can help. Regards
Sean...

 

[Steve Schapel]

Sean

To send the email, have a look at the SendObject macro action.

You can use Windows Task Manager, or some other third party scheduling
utility to automate the running of the report. The Command Line for the
scheduler would probably be of this syntax...
"C:\Program Files\...\Msaccess.exe" "C:\PathToDb\MyDB.mdb" /x NameOfMacro

 

[Guest]

Thanks that great, but...

It comes up with a creating a email on my behalf and could be a virus,
options yes / no.

Is there any way of stopping that happen. It says it is only there for 5
seconds, which is only goo if I am sat at the pc.

I use outlook for emails, apart from that looks great.

Sean...

 

[Mike]

There is a program that will automatically answer this specific question:
http://www.contextmagic.com/express-clickyes/

Mike ...

Thanks that great, but...

It comes up with a creating a email on my behalf and could be a virus,
options yes / no.

Is there any way of stopping that happen. It says it is only there for 5
seconds, which is only goo if I am sat at the pc.

I use outlook for emails, apart from that looks great.

Sean...

Sean

[quoted text clipped - 20 lines]

 

[Guest]

Thanks I will try it out.

Sean...

There is a program that will automatically answer this specific question:
http://www.contextmagic.com/express-clickyes/

Mike ...

Thanks that great, but...

It comes up with a creating a email on my behalf and could be a virus,
options yes / no.

Is there any way of stopping that happen. It says it is only there for 5
seconds, which is only goo if I am sat at the pc.

I use outlook for emails, apart from that looks great.

Sean...

Sean

[quoted text clipped - 20 lines]

I would be most grateful if anyone can help. Regards
Sean...