Solved

How to run a macro at a specific time

Posted on 2004-09-21
6
529 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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Finding original email is quite difficult due to their duplicates. From this article, you will come to know why multiple duplicates of same emails appear and how to delete duplicate emails from Outlook securely and instantly while vital emails remai…
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…
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…

733 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