Hi, thanks for the reply. I've managed to sort now. It appears that running the scheduled task with the 'Higher' privileges* is effectively running it as Administrator. If I make sure Outlook is started as Administrator then the Excel spreadsheet can communicate fine with it.
*the reason I need higher privileges ticked is because if my RDP session locks (which it will do after 5 mins automatically) then the scheduled task just won't run
|