• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 659
  • Last Modified:

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

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
0
sydneyguy
Asked:
sydneyguy
  • 4
  • 2
2 Solutions
 
David LeeCommented:
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.
0
 
sydneyguyAuthor Commented:
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
thanks
0
 
sydneyguyAuthor Commented:
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
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
David LeeCommented:
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: http://www.experts-exchange.com/Software/Office_Productivity/Groupware/Outlook/Q_22037190.html

Here are links to two questions where I use a reminder to trigger a macro:
http://www.experts-exchange.com/Applications/MS_Office/Outlook/Q_21372956.html
http://www.experts-exchange.com/Applications/MS_Office/Outlook/Q_21450551.html 
0
 
sydneyguyAuthor Commented:
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
0
 
sydneyguyAuthor Commented:
code is still on going so will need to revisit this question later on
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now