+ Reply to Thread
Results 1 to 8 of 8

Macro to count the amount of emails in multiple shared inboxes

  1. #1
    Registered User
    Join Date
    03-25-2022
    Location
    denmark
    MS-Off Ver
    2021
    Posts
    4

    Question Macro to count the amount of emails in multiple shared inboxes

    Hello,

    Does anyone know if it is possible to make a macro designed to count the amount of emails within multiple shared inboxes in outlook. In total, there are about 104 shared inboxes that need to have their amount of emails counted each day and exported to Excel.

    Thank you in advance.

    - JSKS

  2. #2
    Forum Expert CheeseSandwich's Avatar
    Join Date
    12-22-2021
    Location
    Kent, England
    MS-Off Ver
    365 - 2402-17328.20068
    Posts
    1,359

    Re: Macro to count the amount of emails in multiple shared inboxes

    Maybe the below would help:
    Please Login or Register  to view this content.
    You will need to be able to access these folders for it to work (privileges)

  3. #3
    Registered User
    Join Date
    03-25-2022
    Location
    denmark
    MS-Off Ver
    2021
    Posts
    4

    Re: Macro to count the amount of emails in multiple shared inboxes

    I apologize for the late reply - I've only gotten around to trying it out now.

    It gives me the following error message when I try to run it:

    error.PNG

  4. #4
    Forum Expert CheeseSandwich's Avatar
    Join Date
    12-22-2021
    Location
    Kent, England
    MS-Off Ver
    365 - 2402-17328.20068
    Posts
    1,359

    Re: Macro to count the amount of emails in multiple shared inboxes

    You will need to add a reference to the Outlook Object Library

    Attachment 779402
    Last edited by CheeseSandwich; 05-05-2022 at 10:28 AM.
    If things don't change they stay the same

  5. #5
    Registered User
    Join Date
    03-25-2022
    Location
    denmark
    MS-Off Ver
    2021
    Posts
    4

    Re: Macro to count the amount of emails in multiple shared inboxes

    Oh duh, of course. I have done that now, thank you.

    New error:

    "Run-time error '-2147221233 (8004010f)' The attempted operation failed. An object could not be found"

    Where Set olFolder = Session.Folders(fldrs(x)).Folders("Inbox") is marked yellow.

    Thank you for your patience so far.

  6. #6
    Forum Expert CheeseSandwich's Avatar
    Join Date
    12-22-2021
    Location
    Kent, England
    MS-Off Ver
    365 - 2402-17328.20068
    Posts
    1,359

    Re: Macro to count the amount of emails in multiple shared inboxes

    Have you changed the line below to contain the names of your shared inboxes?
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    03-25-2022
    Location
    denmark
    MS-Off Ver
    2021
    Posts
    4

    Re: Macro to count the amount of emails in multiple shared inboxes

    Yes, I figured out what the problem was. Thank you so much for your help and have a wonderful day!

  8. #8
    Forum Expert CheeseSandwich's Avatar
    Join Date
    12-22-2021
    Location
    Kent, England
    MS-Off Ver
    365 - 2402-17328.20068
    Posts
    1,359

    Re: Macro to count the amount of emails in multiple shared inboxes

    No problem, you too.

    Just a side note:
    You can mark the thread as solved by using the thread tools option.
    If you feel a user has offered an acceptable solution you are able to add reputation by clicking on the (* Add Reputation) button.

    Cheers,
    Cheese

+ 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 take count of emails in each folder and subfolder from outlook mailbox
    By saurabhlotankar in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-07-2017, 01:33 AM
  2. Excel VBA to count emails each day in shared outlook folder
    By k1989l in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-28-2016, 04:29 AM
  3. Excel Macro using VB Script to send emails from Common/Shared Mailbox
    By k.vijayendran in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2014, 01:48 PM
  4. [SOLVED] Macro To Send Emails with PDF: Multiple Emails and PDF's
    By totoga12 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 03-19-2014, 06:13 PM
  5. Macro to count emails in outlook
    By vijanand1279 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-16-2011, 04:53 AM
  6. chart the amount of emails sent each day
    By Regan80 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-13-2011, 05:01 PM
  7. How to Merge multiple inboxes?
    By L_ter in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 05-30-2009, 06:45 AM

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