Consulting

Results 1 to 9 of 9

Thread: To measure response time between receipt and response of emails from shared inbox

  1. #1
    VBAX Regular
    Joined
    Apr 2016
    Posts
    67
    Location

    To measure response time between receipt and response of emails from shared inbox

    Hi All,

    I have put together a macro to measure response times between the time an email has been received and a reply or forward action taken. Although , macro works seamlessly for a personal inbox, i face trouble in shared mailbox.

    Macro is unable to pick responses ( either reply or forward ) done by various users having access to one shared mailbox. Is there way to capture everyones action and get it into speadsheet. Am pasting the code here. Help would bbe much appreciated.


    Regards
    Karthik
    Attached Files Attached Files

  2. #2
    Your code looks in your default Inbox
    Set myFolder = ns.GetDefaultFolder(olFolderInbox)
    I would imagine that you need to set it to the shared mailbox folder e.g.
     Set myFolder = ns.Folders("Account Name").Folder("Folder Name")
    Graham Mayor - MS MVP (Word) 2002-2019
    Visit my web site for more programming tips and ready made processes
    http://www.gmayor.com

  3. #3
    VBAX Regular
    Joined
    Apr 2016
    Posts
    67
    Location
    Agreed. I should not have sent you this way. I have directed it to shared mailbox. My problem is it picks up all emails from inbox but then responses doesnt get picked up. It only picks the emails I sent or received using shared mailbox.

    I hope the issue is clear now.



    Cheers
    Karthik

  4. #4
    VBAX Regular
    Joined
    Apr 2016
    Posts
    67
    Location
    HI,

    Got a chance too look at this ?

    Regards
    Karthik

  5. #5
    Hi Kartyk,

    Can you provide some guidance as how to install this macro in my personal outlook? I am new to VBA

  6. #6
    The code in the thread is Excel code in an Excel workbook attachment?
    Graham Mayor - MS MVP (Word) 2002-2019
    Visit my web site for more programming tips and ready made processes
    http://www.gmayor.com

  7. #7
    It is a VBA code. Did you mean to ask this?

    I want to use this code in my outlook

  8. #8
    hi kartyk, did you figure it out?

  9. #9
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,812
    Location
    Kartyk hasn't been seen here in four years, I'm Closing his thread. You can start another and link to this one, if you please.
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

Posting Permissions

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