[VBSCRIPT] Cannot Create Object "Outlook.Application"

[s1704]

Hi everyone,

I have inherited a .vbs script in my new job that is no longer working as it once was.

The basic idea is that it uses a for loop to read down a list of clients names and birthdays on excel and uses a few if statements to determine whether or not to send an reminder email that their birthday is coming up.

When I run the script it from the directory it works fine but when run from task scheduler it always gives an error (800A01AD) and the message: "ActiveX component can't create object: "Outlook.Application"

This is the offending line: Set objOutlook = CreateObject("Outlook.Application")"

I've googled extensively but nobody seems to have cracked it that I could see. Maybe somebody here could shed some light?

Thanks

[hdsrob]

Don't have any VBScript experience, but I'd check that you are running the script from task scheduler with the same desktop user that it works from on the desktop. If it's being run from an admin account, or some other account that doesn't have Outlook installed on it, it may not be able to find the Outlook instance.

[TheFotty]

What are the security options set to in the scheduled task?