Outlook Banter - View Single Post - Scheduled Task Fails running Code to send Outlook Mail from Excel.

**Old Man River** · November 12th 09, 06:09 PM posted to microsoft.public.outlook.program_vba

Thanks Ken

Put some debug code in and am getting the error
"Error # 70 was generated by VBAProjectPermission denied" if I use
CreateObject
and
"Error # -2147221020 was generated by VBAProjectAutomation error
Invalid syntax " if I use GetObject.

But thanks anyway. I'll start a new post to see if anyone can tell me what
this error means.

"Ken Slovak - [MVP - Outlook]" wrote:

Did you try what I suggested? If not try it and see if it helps.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm

"Old Man River" wrote in message
...
Thanks Ken but as I understand it Outlook is a single instance programme
so
both GetObject() and CreateObject() are equivalent. Thing is it works
perfectly when manually triggered but fails in a scheduled task!

.