+ Reply to Thread
Results 1 to 3 of 3

Excel VBA to count emails each day in shared outlook folder

  1. #1
    Registered User
    Join Date
    05-06-2015
    Location
    England
    MS-Off Ver
    2014
    Posts
    71

    Excel VBA to count emails each day in shared outlook folder

    Hi Everyone,

    I have looked online and on here and can not seem to find my answer anywhere.

    We have a shared folder at work, and I need to be able to count how many emails are sent to it each day.

    I have found things online like this:

    Please Login or Register  to view this content.
    edit:problem is that due to the amount of emails in the folder it is taking forever to run, is there any way of checking just the last months or another way of speeding this up?!?!?


    Thankyou in advance,

    Katy
    Last edited by k1989l; 10-28-2016 at 04:31 AM.

  2. #2
    Registered User
    Join Date
    05-06-2015
    Location
    England
    MS-Off Ver
    2014
    Posts
    71

    Re: Excel VBA to count emails each day in shared outlook folder

    Hi Everyone,

    This works but takes forever to work through because of the amount of old emails in the folder.

    Is there any way of making it just look at the emails within the last month? or anything else that will speed it up?

    Thanks

  3. #3
    Registered User
    Join Date
    05-06-2015
    Location
    England
    MS-Off Ver
    2014
    Posts
    71

    Re: Excel VBA to count emails each day in shared outlook folder

    Sorry to bump but does anyone have any ideas about this before I just get rid of the post

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to fetch the name from the signature of outlook sent folder emails
    By Manish_Gupta in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-22-2015, 03:24 AM
  2. Copy all emails in outlook folder and paste them in similar system folder and ms access
    By Megatronixs in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-28-2014, 07:31 AM
  3. [SOLVED] Import MailItem properties from Outlook shared folder(s) to Excel
    By kaptenstofil in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2014, 05:26 AM
  4. [SOLVED] copy emails from outlook into a folder
    By plans in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-16-2014, 02:26 PM
  5. shared folder outlook vba
    By dulitul in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2013, 04:21 AM
  6. [SOLVED] Select folder and date range to get emails from Outlook
    By 2sqrd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-29-2013, 09:51 AM
  7. Import emails from outlook folder as TXT
    By Mslady in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-07-2005, 08:07 PM

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