Macro which creates logs of outlook in excel

Dear Gurus,

Can some one give me macro which creates logs of outlook in excel.

(Sorry if some one already had asked this question. please forward me link if its already solved post.)

I want to create a button with function of this macro. So that, when I select any email ( from inbox or sent items) and by clicking macro button, it should create logs of selected email in one excel workbook.

Logs should be of:
1. Date of email (sent/received)
2.Type of Email (sent or received)
3 Email Id (of sender/reveiver)
4. Subject
5. Hyperlink to open that email (from excel)


Thanks in advance.

Dear Ali,

I guess this is what you are looking for:

http://www.mrexcel.com/forum/excel-q...-activity.html

best,
Felipe