Outlook 2000 customization
Posted on 2009-05-09
I would like to customize Outlook as follows.
1) When I open an e-mail the time that the e-mail was sent is logged into an Outlook field
2) When I reply the time of the reply is pumped into another field as well as the 'subject' line
3) After back and forth with the corrrespondent I want to be able to send a 'sign off' e-mail at which point the sending time of this 'last' e-mail is dumped into yet another field in Outlook. At the same time a fourth field is filled in with the difference in time between the first field and the last field.
So for instance if I get an e-mail request at 1:00 AM Friday the 13, 2013 and I reply to it at 1:05 AM Friday 13, 2013 and then there is further back and forth and finally I send an e-mail 'done' at 1:13 AM Friday 13, 2013 at the end of an e-mail exchange I will have the following fields available to me:
subject line of e-mail
receipt of request - 1:00 AM Friday the 13, 2013 (in some appropriate date format
reply to request - 1:05 AM Friday 13, 2013
confirm completion - 1:13 AM Friday 13, 2013
elapsed time - 8 minutes
Assuming that this e-mail exchange is the kind where each person's response keeps being added to the trail, ideally I would want the final e-mail that I send to have the above fields embedded into it so that if I did want I could export it to a spreadsheet.
If doable would this best be done through a macro? VB?
Thanks in advance