+ Reply to Thread
Results 1 to 2 of 2

Speeding up an Outlook macro

  1. #1
    Registered User
    Join Date
    02-24-2017
    Location
    France
    MS-Off Ver
    2007
    Posts
    62

    Speeding up an Outlook macro

    Hello, I have a VBA macro in my Outlook, which takes around 60 minutes to process around 45k emails. I was wondering, whether there is a way to somehow speed it up. I'd be very grateful for some suggestions? Many thanks. Here's the code

    Please Login or Register  to view this content.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    2010, 2013, 2016
    Posts
    10,569

    Re: Speeding up an Outlook macro

    It might be possible to squeeze a little more performance out of this, but that's a rate of 0.08 seconds per email. For the processing you are doing, which includes file operations, that seems pretty fast to me.

    Your code would be easier to read if you cleaned up the indentation. It's hard to tell what If statement is inside what For loop is inside what If statement.
    Jeff

    Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會

    If someone helped you, please click on the star icon at the bottom of their post
    If your problem is solved, please go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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