Log in

View Full Version : To measure response time between receipt and response of emails from shared inbox



Kartyk
04-20-2016, 03:16 AM
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

gmayor
04-20-2016, 04:13 AM
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")

Kartyk
04-20-2016, 04:23 AM
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

Kartyk
04-20-2016, 11:49 PM
HI,

Got a chance too look at this ?

Regards
Karthik

Fabian76
10-15-2017, 09:31 PM
Hi Kartyk,

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

gmayor
10-16-2017, 08:43 PM
The code in the thread is Excel code in an Excel workbook attachment?

Fabian76
10-16-2017, 09:05 PM
It is a VBA code. Did you mean to ask this?

I want to use this code in my outlook

anonymouse12
07-05-2021, 12:23 AM
hi kartyk, did you figure it out?

SamT
07-05-2021, 05:13 AM
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.