Community discussion forum

Outlook VBA query

• • Reply

  1 month ago

  by NaseemAhmed

  Shaik Naseem Ahmed

  , India

  Joined 1 year ago

  Hi All,

  Plz let me know if this is possible through to do through Outlook VBA:

  From the time we start outlook it should start running one application which will through a message box every one hour.....

  when i start the outlook....it should record the start time and it should keep running....if the time interval is exactly 1 hour...it should through a message box....

  is this possible through outlook VBA...?

  regards, SK

  Report abuse
• Advertisement

  Simply the fastest line-level profiler for .NET ever

  “The low overhead means it has minimal impact on the execution of my program”
  Mark Everest, Development Team Leader, Renault F1 Team Ltd.

  Try out the new ANTS Profiler 4 for yourself. Download your 14-day trial now

• • Reply

  1 month ago

  by James Crowley

  James Crowley

  London, United Kingdom

  Joined 7 years ago

  Hi there,

  Yes that should be possible. You could use a timer that you start when the VBA code initializes, and then fire off the messagebox after an hour has elapsed. It's not the easiest of things to get timers working in VBA, I believe, but check out this article - http://www.cpearson.com/excel/OnTime.aspx - that should help.

  All the best

  James

  Report abuse