outlook calling a macro from the tools >> options >> mail send/recieve >> schedule aout send recieve

Posted on 2007-09-30
Last Modified: 2010-04-21
On timer event I want to simply call a macro
thats it at present I have outlook configured using no forms but using the timer to check the mail server every 5 min and if it returns new mail then it will run the appropiate macro eg  Application_NewMail() this works fine. but if no mail arrives the function does not run as you would expect. what I require is the code for the call so when the time set up under options it will fire off a macro  for me..
should be simple just have not been able to find the code line to do it..
thanks in advance
Question by:sydneyguy
    LVL 76

    Accepted Solution

    Hi, sydneyguy.

    If you need to fire a macro at a set interval, then you'll need to go a different route.  A scheduled send/receive doesn't fire any events I know of that can be trapped for this purpose.  I can suggest two possible solutions.  One, use a task item's Reminder event.  Two, use a timer.  I can point you to examples of both if you're interested.

    Author Comment

    this is what I wanted to know was I wasting my time looking for an event trigger that does not exist or do I need to go a different route, yes please examples would be very handy

    Author Comment

    BlueDevilFan: I was wondering if youhad these examples for me please, still cannot find the info in fact I cannot even find the timer to plac on the form to even configure it. Looked all over the place but just cannot locate it. at preset have opened a ne form in the Macro area. using outook 2003 any ideas
    LVL 76

    Assisted Solution

    by:David Lee
    Hi, sydneyguy.

    Apologies for being so slow.  

    Here's a link to a question I participated in that has a good example of a timer routine:

    Here are links to two questions where I use a reminder to trigger a macro:

    Author Comment

    I now have a bit more knowledge on what I am doing, as is what happens, so will be revisiting the above mentioned articles to see what I can extract out of them, now me needs are more defined

    Author Closing Comment

    code is still on going so will need to revisit this question later on

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
    Check out this infographic on what you need to make a good email signature that will work perfectly for your organization.
    Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

    728 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

    22 Experts available now in Live!

    Get 1:1 Help Now