Calculate the Response time of a thread

Status
Not open for further replies.

Haritha

New Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server
Hello,

I am trying to find a way to calculate the total time taken to close an Email thread in Outlook and export the results to an excel spread sheet . Please advise and share your thoughts .

Regards.
 

Haritha

New Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server
Hello,

I am trying to find a way to calculate the total time taken to close an Email thread in Outlook and export the results to an excel spread sheet . Please advise and share your thoughts .

Regards.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
I would use the CFG that shows the replied to time, add it to a list view then copy and paste into Excel. If you needed to do it a lot, you can use a macro to send the same info to Excel.

See http://www.slipstick.com/exchange/adding-extended-mapi-fields-to-outlook/ for the first option. I'm not sure if i have any sample code that will automate it, at least not the fields you need - this macro could be tweaked to do it - http://www.slipstick.com/developer/vba-copy-outlook-email-excel-workbook/ - you won't need the regex stuff after Set olItem = Application.ActiveExplorer().Selection(1) and will replace that code with the fields you need.
 

Haritha

New Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server
Thanks Diane . I will explore your suggestions .

Regards,
Haritha
 
Status
Not open for further replies.
Top