Daily Macro Log-In Problems, ...?

[Bill]

I need a macro to run daily that will do the following:
1) run a create table query
2) email query to recipients

Seems simple,... but it's not.
I arranged for the Windows Scheduler program to run the macro, ... and I
have installed the Click Yes program to avoid user confirmation for sending
the email, ... BUT, the macro will only run if the computer is not locked.
How can I get this to run, ... while preserving me some security at the
office.

Thanks!
Bill