Solved

How to run a macro at a specific time

Posted on 2004-09-21
6
521 Views
Last Modified: 2008-02-01
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.
0
Comment
Question by:cindyrod
  • 3
  • 3
6 Comments
 
LVL 15

Expert Comment

by:will_scarlet7
ID: 12113294
Hi Cindy,
    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
0
 
LVL 1

Author Comment

by:cindyrod
ID: 12169052
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
0
 
LVL 15

Accepted Solution

by:
will_scarlet7 earned 250 total points
ID: 12169588
Hi Cindy,
    How proficient are you at VBA programming? Technicaly, I believe what you propose is possible. However I was unable to get it to work (note: I am not a experienced Outlook programmer, nor did I spend a lot of time trying.) so I can not help with any solid practical help. I think a good place to start would be to either Buy a good book on Outlook programming (like "Microsoft Outlook Programming") or search online for samples. In my brief search I was unable to find an samples of exactly the process of trapping the reminder events, but acording to the following excerpts it should be trappable:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnolbk02/html/odc_ch11olevents.asp

If you still want to go this route I'll be happy to offer what help I can.

God bless!

Sam
0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
LVL 1

Author Comment

by:cindyrod
ID: 12257876
I'll try to use that. I'll let you know as I work on it. Thanks for your help.
0
 
LVL 1

Author Comment

by:cindyrod
ID: 12318013
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.
0
 
LVL 15

Expert Comment

by:will_scarlet7
ID: 12318864
ThanX for the points Cindy!
God bless!
Sam
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Get an idea of what you should include in an email disclaimer with these Top 5 email disclaimer tips.
Follow this checklist to learn more about the 15 things you should never include in an email signature from personal quotes, animated gifs and out-of-date marketing content.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now