Solved

How to run a macro at a specific time

Posted on 2004-09-21
6
530 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this step by step procedure, you will come to know the details of creating an Outlook meeting in 2007, 2010, 2013 & 2016.
How to resolve IMCEAEX NDRs in Exchange or Exchange Online related to invalid X500 addresses.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

705 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