Results 1 to 6 of 6

Can I trigger a VBA script without pausing Outlook for the duration?

Threaded View

baldmosher Can I trigger a VBA script... 08-05-2013, 05:04 AM
ragulduy Re: Can I trigger a VBA... 08-05-2013, 05:20 AM
baldmosher Re: Can I trigger a VBA... 08-05-2013, 05:37 AM
ragulduy Re: Can I trigger a VBA... 08-05-2013, 05:52 AM
baldmosher Re: Can I trigger a VBA... 08-05-2013, 07:12 AM
baldmosher Re: Can I trigger a VBA... 08-05-2013, 07:19 AM
  1. #1
    Registered User
    Join Date
    09-27-2012
    Location
    Manchester, GB
    MS-Off Ver
    365,2016,2013,2010,2007,2003
    Posts
    17

    Can I trigger a VBA script without pausing Outlook for the duration?

    This might seem a little backwards, but I've spent the last 9 months developing a complicated system of very effective VBA scripts for Outlook automation, but now I'm asking a fairly simple n00b question.

    Can I have Outlook run a script, but leave Outlook usable whilst running it?

    Background: despite having the VBA code for Event triggers to launch scripts when an email arrives, I've not found it to be reliable enough (admittedly I've not tried it again since I upgraded from 2003 to 2010 - so I might try it again). So instead, I use an Outlook Rule to trigger the script when an email arrives with certain keywords (e.g. when an attached report arrives with AUTORUN in the mail subject). But this approach hangs Outlook throughout the script, and if something is taking longer than expected to run, e.g. if a shared drive is particularly slow (or as happened last week, if I've made a mistake in the setup and I'm running an Update query that takes 6 hours to run!!), I've rendered Outlook unusable for a whole day. I don't know if switching to Event triggers would even change that.

    I've thought about creating a new Outlook.Application instead of using the intrinsic Application object but my experience with Excel VBA tells me that that wouldn't make any difference. However, with no formal training in VBA maybe I've missed a trick there too...!!

    I've also thought about manually starting a new session of Outlook but I'm worried that'll just start running the same scripts twice......

    I've also just thought that maybe using Shell is the answer...?

    Help appreciated, and sorry if I've posted this in the wrong support forum
    Last edited by baldmosher; 08-05-2013 at 05:31 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VB Script to Pull Outlook Properties for List of IDs or Names
    By navs8603 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-24-2013, 02:18 AM
  2. [SOLVED] Formula: To calculate duration between two times, if duration is over 6hours subtract 30mi
    By MattBarnes7 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-11-2013, 03:22 PM
  3. Script to fetch PDF file from Outlook and process it to Excel.
    By neaz1st in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-14-2012, 01:31 PM
  4. Pausing Code to Trigger Other Events
    By SDruley in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2011, 01:53 PM
  5. Reply to outlook email from excel script
    By theerdman@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-21-2006, 12:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1