Access database fails when using Task Schedular

[June7]

This is what I use:



Dim appOutLook As Outlook.Application
Dim MailOutLook As Outlook.MailItem
Set appOutLook = CreateObject("Outlook.Application")
Set MailOutLook = appOutLook.CreateItem(olMailItem)
With MailOutLook
...
End With

And now that I have the ScheduledTask settings figured out, the above executes when db opens from the task, no script file middleman.

[tcheck]

Thanks. Are you using Win 7 or XP for TS?

[June7]

I just tested with XP and Access 2007.