[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

How to run a macro at a specific time

Posted on 2004-09-21
6
Medium Priority
?
536 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 1000 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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

When you have clients or friends from around the world, it becomes a challenge to arrange a meeting or effectively manage your time. This is where Outlook's capability to show 2 time zones in one calendar comes in handy.
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
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…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

656 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