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.
Thread starter Similar threads Forum Replies Date
ThinkToday Calculate reply time of outlook mail Using Outlook 1
Diane Poremsky Calculate Days Overdue and Days to Complete Tasks New Slipstick.com Articles 0
M Moving mailboxes from Exchange 2003 to 2010 - how to calculate move request batch size? Exchange Server Administration 3
W How do I calculate the next recurrence date? Outlook VBA and Custom Forms 1
F Automatically calculate age from birthdate Outlook VBA and Custom Forms 2
M VBA to send reminder email if no response Using Outlook 13
B Removing Recipients from an automatic response Outlook VBA and Custom Forms 2
J No response required when delegate arranging meeting Using Outlook 0
N automatic response with an attachment based on the subject line Outlook VBA and Custom Forms 1
K VBA to measure response time for each emails in a shared mailbox Outlook VBA and Custom Forms 11
cabinet guy permanent response in html Using Outlook 1
V "Accept + Send the Response now", VBA script? Using Outlook 1
A automatically remove flag from original message when a response was received Using Outlook 2
D Frequently used response short cut possible macro Using Outlook 1
L Outlook Meeting Response: determine when a meeting response has been edited Using Outlook 1
M Auto response from Outlook Using Outlook 1
M No response required message Using Outlook 1
N Slow / non response trying to pass from one folder to other (both in OUTLOOK.PST) Using Outlook 2
J Getting 5102. Server. Xfs request 'SyncBinary' failed. Response code: 'Undefined' Using Outlook 2
U Outlook 2010 email auto response on Monday and Tuesday Using Outlook 1
M EWS Managed API: Long time between request and response Exchange Server Administration 1
S Event ID: 5/6/7 - Malformed SOAP Response? Exchange Server Administration 10
T Automated Response To Emails Using Outlook 2
R What controls the response to clicking an email link? Using Outlook 1
J auto response to e-mail Using Outlook 2
B Microsoft Word error as a part of Outlook locking up and not allowing an e-mail response. Using Outlook 1
K Outlook 2010, CRM 4.0 Client for outlook (rollup 13) gets undeliverable response replying to CRM linked email Using Outlook 3
C The WInRM client sent a request to an http server and got a response saying the requested http url w Exchange Server Administration 1
R Error code 0x8004210B The operation timed out waiting for a response from the sending (SMTP) server. Using Outlook 1
H Error: 5102. Server. Xfs request 'SyncBinary' failed. Response code: 'Undefined' Using Outlook 1
S HELP: Email body transcript deleted when receiving response emails Outlook VBA and Custom Forms 1
C Exchange 2010 UM with OCS 2007 R2 - SIP OPTIONS response failure with Front End? Exchange Server Administration 23
P Retrieve Meeting Response Text Associated with an Appointment Outlook VBA and Custom Forms 1
H Active directory response: 00002098: SecErr: DSID-03150BB9, problem 4003 (INSUFF_ACCESS_RIGHTS), dat Exchange Server Administration 6
R Disable conversation thread from replying of recipients in the same subject. Please help Using Outlook 0
S Conditional Formatting for messages in a Conversation thread Using Outlook 1
D Convesation Thread Duration Outlook VBA and Custom Forms 2
E Outlook 2010 Subject sort uses Thread-Topic for grouping Using Outlook 2
wallisellener Unable to reply/post/create new thread using Chrome BCM (Business Contact Manager) 5
wallisellener Another BCM Authentication thread BCM (Business Contact Manager) 5
H Another OWA Timeout thread - possible Forms/Basic Authentication with IIS issue Exchange Server Administration 1
A 4.3.2 432 STOREDRV.Deliver; recipient thread limit exceeded Exchange Server Administration 6
E Link doesn't work. http://social.technet.microsoft.com/Forums/en/office2010/thread/2d18b9e6-dac5-455 Using Outlook 1
S RDOMail object is not working in different thread. Outlook VBA and Custom Forms 13
Similar threads












































Top