I have written a VBA function in MS Outlook that takes about 30 seconds to run. It needs to open and read data in a spreadsheet as well as loop through emails. I need the application to run every 30 minutes or so to see if there have been any new emails arrive or any updates to the spreadsheet. The trouble is that if I am using MS Outlook at the time it will interrupt and make me wait so I was wondering if there is a way to run it without interfering.
I was thinking that perhaps it may be possible to create an instance of Outlook and Excel using VB Script or perhaps running it from another MS product that I don't use very often like Publisher or Powerpoint, or perhaps I should create a virtual machine and leave an instance of Publisher running on it (though that will likely be very resource hungry). I don't think this is a new problem so I am hoping someone has a relatively straightforward suggestion.