Outlook emails fail to be sent

[syswizard]

I have an Access database update process that is run from the Win7 scheduler. I have attempted to instantiate or reference Outlook and send an email indicating the status of the process.
Outlook fails for some reason, but it works fine interactively regardless of whether Outlook is running or not.
I am now thinking of trying SendObject instead.
Any thoughts or ideas ?

 

[spikepl]

"fails"? Watch it on test and see what happens, otherwise everybode can just keep guessing. If it is the security thing the google CDO or Redemption. There is alse some less-than-authorised code I think called ClickYes. If you do not know what "the security thing" is, then it's probably not the cause.

 

[syswizard]

AN update: I got it to run today on my machine. I made a slight change to the command line args on the server machine. We'll see in the morning.....if that fixed it.

 

[syswizard]

Still didn't work....one thing missing: there is no Application.Quit in the procedure that is executed.

I am going to insert that conditionally based on Application.UserControl value.
I am also going to try to use SendObject to see if that works.