Hi I am using outlook 2007.


I will be given few emails everyday, I need to open each of them and capture the following information and store it to excel.

Information to be captured:
1) when was that email originally sent, who sent it , what was the message,
2) who first replied to it and when,
3) who is the last reponder to the email and when was that sent.

I would like to have a macro that capture these info when I open a email and store it to excel upon a key stroke. Can this be done/possible, this would save lot of manuall effort.

For example:

When I open the below sample email and run the macro, I need to capture the following.

1) Original Sender info: name1/Test1/Sunday, November 14, 2010 7:09 AM
2) The first reply info: name2/Sunday, November 14, 2010 8:00 AM
3) The last sender info: name3/Sunday, November 14, 2010 8:00 AM

Sample email:
----------------------------------------------------------------
From: name3
Sent: Sunday, November 14, 2010 9:09 AM
To: DL
Subject: Re :Article

Test3
----------------------------------------------------------------
From: name2
Sent: Sunday, November 14, 2010 8:00 AM
To: DL
Subject: Re :Article

Test2
----------------------------------------------------------------
From: name1
Sent: Sunday, November 14, 2010 7:09 AM
To: DL
Subject: Article

Test1

----------------------------------------------------------------



Thanks,
Qk