E-Mail Automation

[Tony]

Hi All,

I have a database that generates two reports that need to be e-mailed to an
end-user. The setup is as follows:

-Access 2003 database on Windows 2003 Server
-Reports generated overnight
-Reports to be sent to user using SendObject
-Module that sends reports is run from .vbs file
-.vbs file is launched by scheduled task
-SendObject uses an Outlook Express account to send mail

This all works, assuming that I am logged into the server and manually run
the scheduled task that kicks everything off. However, the process
consistently fails (when it attempts to run on schedule when no one's logged
into the server) on SendObject. When I check it in the morning, the first
report that should have been sent is sitting in the database, a lock file is
sitting in the folder where the database lives, and Access is open in the
background. There are no error messages when I log in and nothing in the
event logs indicate that there were issues.

It seems as though somehow I have to automatically log in to the server long
enough for the processing to take place then log out. Anyone have any idea?

Thanks & Ciao

 

[SJ]

It sounds like the Scheduled Task is logging on as some user that is
different to the user logged on when you test it manually.

 

[Tony]

Hey SJ,

Thanks for the reply. I'm using the same logon credentials in both places.
The Outlook Express account is using different credentials, but I suspect
that doesn't make a difference, particularly since the process runs
manually. But, that's something to look at...

Thanks & Ciao

Tony