Macro works normally in the db, but fails to send email when run in task scheduler

[Pack10]

I have a nightly job that refreshes tables in an Access db.
It's a macro which runs query after query. About 15 or so. At the end, i send an email
to myself that I know the job ran successfully. Here's the wierd thing.
If I run the macro from within the db, it runs fine, it sends the email, if i run it thru
the Microsoft Scheduler, It does not send the email out. I am using Access 2007 and Windows 7.

 

[SkipVought]

Hi,

How are you sending mail?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Pack10]

I am using outlook objects

 

[Pack10]

Just wanted to mention that i figured this one out...when in doubt and you've tried most everything...start with a new database container and import all the objects in because these database containers do get "banged up".