Solved

How to run a macro at a specific time

Posted on 2004-09-21
6
526 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
Many people use more than one email account and so it becomes difficult for them to manage them when they use separate accounts,  so, in this article, I have shared an easy way to add Other Mail Accounts in your Google Inbox. It helps to combine all…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
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…

770 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