Automating Email Excel VBA/Outlook and Windows Scheduler

[rasage]

Hi,

I have an Excel Utility that automatically opens using the windows scheduler, the code is run using the workbooks Workbook_Open sub-routine.

I have utilized an email work-around (

http://www.dimastr.com/redemption/)

of the Outlook security alert pop-up box.

I am having a problem with the emails getting caught in the drafts folder and not executing the *second time.
-----------------------
Set Sync = NS.SyncObjects.Item(1)
Sync.Start
------------------------
This preceding works the first time, but after Outlook is already opened, the second scheduled attempt at running the macro, is stuck in the Drafts folder of Outlook.

...Or after the process runs, it will not run again until after the machine is re-booted. I am trying to set up a process that requires minimal Human involvment.

Any ideas?


Thanks for any and all help.
Rasage