tracking time of emails

Status
Not open for further replies.
H

hello147

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Want to see if all mails from each client (there are around 25) have been responded timely. I want that whenever an email is sent to a particular client (each client email will have a unique identity number in it) then in an excel sheet or in some other format I could get the result showing me at what date and time it was sent and at what date and time the reply has been received along with the calculation of their difference i.e. how much time it took to respond it. Their might be several follow ups on same email and each such conversations information will be required. Hope i am clear in my explanation of requirement. Can this be done?
 
Just to add to the above that there are 3 people working on around 8 different clients each and i want to track everyone's mails.
 
You'll definitely need a macro or utility - Michael Bauer has a report utility that might do what you need - and there are others - see Outlook Reporting Tools and Utilities - Michael's in VBOffice Reporter.

I have a macro somewhere that gets the times - I found this one that could be tweaked Forward Messages that were not Replied To - but I'm sure I have one that creates a report. (It might be in this forum.)

If your needs are simple, you can copy and paste and use excel to calculate the times. Use this to get the replied to time How to display the sender's email address in Outlook - and use a custom view with the reading pane off, copy and paste.
 
Status
Not open for further replies.
< Macro to set contact reminder to next day 9:00 | Calling a Public sub-routine from the script editor via VB script >
Similar threads
Thread starter Title Forum Replies Date
R Outlook for Mac - Advanced Search and Tracking Sent Emails Using Outlook 0
S My Draft Emails Have Review Tracking Using Outlook 7
rino email campaign - tracking opened emails Outlook VBA and Custom Forms 6
D tracking emails in outlook 2010 Using Outlook 1
J Tracking sent emails Using Outlook 3
C Tracking Calendar Changes? Using Outlook 1
L Attachment saving and tracking - PLEASE help! Outlook VBA and Custom Forms 5
N Tracking Mail items being moved to folders Outlook VBA and Custom Forms 5
N Activity Tracking with Userform Outlook VBA and Custom Forms 4
C Problem tracking meeting responses Using Outlook 3
C Rule to Handle Meeting Replies that updates tracking information Using Outlook 2
M Room Reservation request showed "None" in Tracking-View Tracking Status. Exchange Server Administration 0
C Tracking WHO deleted items in a Shared Mailbox Using Outlook 1
S How to remove tracking from printing - outlook 2010 Using Outlook 4
R Can't use "manage linking and tracking" BCM (Business Contact Manager) 10
P Tracking BCM Users BCM (Business Contact Manager) 1
K add an email to a business contact without linking/tracking sender BCM (Business Contact Manager) 0
K add an email to an account without linking and tracking the email address BCM (Business Contact Manager) 0
D Tracking meeting request responses in Outlook Outlook VBA and Custom Forms 16
B How to Remove Scheduling and Tracking on the Custom Meeting Form Outlook VBA and Custom Forms 4
F Tracking email in Outlook BCM (Business Contact Manager) 1
E BCM for Job Search Tracking? BCM (Business Contact Manager) 1
Thomas Fast Best way to manage incoming customer emails automatically in Outlook? Using Outlook 1
R VBA Macro for Archiving IMAP Emails to PST Outlook VBA and Custom Forms 3
C How to keep emails in account in Outlook after closing the IMAP account Using Outlook 1
A Missing Sent Emails in New Outlook Using Outlook 18
A Outlook 365 Can I set up a Microsoft 365 account to capture emails sent and received from a comcast.net account? Using Outlook 7
A New Outlook - Cannot drag IMAP emails to Task List in MyDay Using Outlook 1
T Emails with attachments from an alias are undeliverable to one of three aliases Using Outlook 2
T Outlook 2019 While connecting an IMAP account in "classic" Outlook 2024 I caused a massive duplication of emails on the server (death loop) Using Outlook 5
B Arrows missing from Outlook emails vertical scrollbar Using Outlook 0
G Cannot receive emails from gmail account in Outlook 365 Using Outlook 1
J Saving Send emails to a folder on the server Outlook VBA and Custom Forms 65
D Amazon and some other emails not showing in Preview Pane Using Outlook 10
J Outlook 2019 Pick the Folder Location to save send emails Outlook VBA and Custom Forms 0
Retired Geek Outlook on MAC delete duplicate Sent emails Using Outlook 0
J Emails with .ICS calendar invitations attached don't contents when received in Outlook 365 Using Outlook 6
W Outlook 2021 Hanging on "Sending Emails" Using Outlook 3
M Outlook 365 VBA Auto-Forward Only the first of Duplicate Emails Outlook VBA and Custom Forms 2
J Action based on number of emails after sort by from Using Outlook 3
D Can't read some emails - text size too small. Using Outlook 2
R How to use VB .Net to send emails? Outlook VBA and Custom Forms 0
T Outlook is categorizing emails incorrectly Using Outlook 0
H Move Selected emails to Local Drive Outlook VBA and Custom Forms 0
D Delete Outlook emails from MS server Using Outlook 17
G Creating Macro to scrape emails from calendar invite body Outlook VBA and Custom Forms 6
A Flagged Emails highlighted in yellow Using Outlook 3
P Search folder: all emails sent to or from a domain Using Outlook 1
J Macro to Reply to Emails w/ Template Outlook VBA and Custom Forms 3
G Save emails as msg file from Outlook Web AddIn (Office JS) Outlook VBA and Custom Forms 0

Similar threads

Back
Top