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

Your code looks in your default Inbox

Code:

---

Set myFolder = ns.GetDefaultFolder(olFolderInbox)

---

I would imagine that you need to set it to the shared mailbox folder e.g.

Code:

---

Set myFolder = ns.Folders("Account Name").Folder("Folder Name")

---

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

HI,

Got a chance too look at this ?

Regards
Karthik

Hi Kartyk,

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

The code in the thread is Excel code in an Excel workbook attachment?

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

I want to use this code in my outlook

hi kartyk, did you figure it out?

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.