Need VBA Code to Copy & Paste Only Subject & Received Time of an E-Mail into Excel!

Dear Friends,

Please open this attachment

E-Mail Lists Work Sheet:-

In this, I have defined From E-Mail ID & To E-Mail ID which is default (Will not change very often).

What I would like to accomplish here is,

The moment there is an E-Mail alert From: this particular E- Mail ID to mentioned To: E-Mail ID

I want that Received Time & Subject of the E-Mail to get updated in Raw Data Work Sheet Column B & C Accordingly (one below one).
Note: This Excel Workbook will be saved in a centralized Network path. Link looks something as below….

\\CompanyName\DivisionName\Functions\DepartmentName\ExcelFile

Could you please suggest, How to achieve this?

Thanks & Regards,
Rajeshkumar R

Dear Experts,

Is this impossible to make it happen? Do you have any other possible alternate suggestion to achieve Subjected Query?

Basically I would like to record & track whatever the E-Mail coming from a particular address & publish the summary of Open & Close to the Team?

Looking forward some positive feedback on this!

Thanks & Regards,
Rajeshkumar R

Dear Experts,

I found some kind of possible suggestion in the below link. However, due to my lack of knowledge am not able to modify the coding to accomplish subjected query.

http://stackoverflow.com/questions/8...ook-with-excel

Could you please help me for the same?

Thanks & Regards
Rajeshkumar R