++outlook automation

[fi.or.jp.de]

Hi All,

I am using outlook 2003 & excel 2003.

I need a excel macro to identiy the current or Active mail clicked or
opened in outlook mail box.

The details like subject & sender name should pop up as message box

Please let me know how to achieve this.

Thanks in advance