Hi All,

In my company i have a shared mailbox which is accesses simultaneously by 2
persons. At the end of the month we are tracking the emails which we received
and emails we replied.

Is any way to copy the details of emails such as sender name, time, and
subject to a excel sheet whenever any new mail comes to my shared mail box.
Am looking for a VBA code which will automate the above task when ever a new
mail comes to my shared inbox.

Many thnaks for your help.

Sunil

Have you tried the journal in Outlook? Of course, not everyone uses Outlook
as their email handler, but if they do, the Journal provides all that data.

"Sunil" wrote:

Hi All,

In my company i have a shared mailbox which is accesses simultaneously by 2
persons. At the end of the month we are tracking the emails which we received
and emails we replied.

Is any way to copy the details of emails such as sender name, time, and
subject to a excel sheet whenever any new mail comes to my shared mail box.
Am looking for a VBA code which will automate the above task when ever a new
mail comes to my shared inbox.

Many thnaks for your help.

Sunil