Automating Scheduled Routines In MS Office

[ColinKJ]

Hi All,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Can anyone tell if it is possible to use Tasks or any other facility within Outlook to automatically active an Excel program.
<o></o>
For some of us, one of the first things we activate when we switch on our PCs is Excel, in which we can program for regular routines to run automatically, but for a lot of our colleagues, the first thing they open is Outlook.
<o></o>
And while Outlook can remind them to undertake regular routines, for some routines, I would like Outlook to be able to automatically run some scheduled routines.

<o></o>
Any suggestions.

 

[Ruddles]

When Outlook starts, it runs the Application_Startup event handler - assuming macros are enabled. Whatever code is in that handler will be executed at that time, so could you use that?

Obviously you can open Excel worksheets and Access databases using VBA, examine a user's Outlook Calendar and Tasklist, etc, or use it to run automated tasks.

 

[ColinKJ]

Hi Ruddles,

Thanks for your response, I'll take a look at the Application_Startup event handler in Outlook and see how I get on.

 

[ColinKJ]

Hi Ruddles,

I tried out the Application_Startup event handler in Outlook with a greeting message, and it worked fine when I opened Outlook.

I haven't done much VBA in Outlook, but I'll have a look around and see how I get on.

I may be back to you if I hit a brick wall.

Thanks again for your help.

 

[Ruddles]

I haven't done much VBA in Outlook...

Nor have I!