cindyrod
asked on
How to run a macro at a specific time
I would like to setup a macro to run every Monday morning in Outlook 2002. I guess that Outlook has to be open for the macro to run, so I would like the macro to run as soon as Outlook is opened on Monday morning.
ASKER
I was thinking that I could also create a reminder in Outlook and write a macro that runs every time that the reminder appears. This way even if the user doesn't open Outlook until, let's say, Wednesday evening, he/she will still see the reminder and the macro will run. Now, is there a way to run a macro when a reminder shows up or something like that?
Thank you,
Cindy
Thank you,
Cindy
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I'll try to use that. I'll let you know as I work on it. Thanks for your help.
ASKER
I decided not to go with this approach (not yours, just not to run the macro every morning) because it would slow down Outlook in some of the machines where the user has dozens and dozens of reminders. What I wanted to do was to provide a link to an application when the reminder showed up, but I don't think that this will be necessary anymore. Thank you for your help.
ThanX for the points Cindy!
God bless!
Sam
God bless!
Sam
You can write a MACRO that fires each time Outlook opens and if it is Monday morning performs a specific task. This could be somewhat limiting though. What if the user does not open outlook till 5 minutes to late? Rr if you compensate for that by setting a broader timeframe, what if the user opens Outlook 2 or 3 times in that timeframe?
Another suggestion would be to write your MACRO in another Office document (Word, Excel or Access) then have the a scheduled task set to open that document at a specific time on that computer computer.
God bless!
Sam