Macro for Email Activity

[DJWH]

I sit possible to run a macro that will record email activity from an Outlook inbox and store it in a Excel file. For example, the date received and the subject line for every email that comes into an inbox would be logged.

Many thanks in advance

 

[AMIT2179]

Hi. i am using this macro but getting an error on line

LR = Range("A65536").End(xlUp).Row

can anyone help??

 

[jay_jj]

Thanks. I still get an error in that line. It says:

Run-time Error '-2147221233 (8004010f)':

The operation failed. An object could not be found.

Is it to do with "GetNamespace("MAPI")"?

Hello Sir,
I am finding the same difficulty but the Error code is little diffferent as

system error &H80070057 (-2147024809). Please help me on this I have read all your posts on this, I am new user of macro n need ur guidline on this.</SPAN> <TBODY> </TBODY><COLGROUP><COL></COLGROUP> </SPAN>

</SPAN>

<TBODY>
</TBODY><COLGROUP><COL span=2></COLGROUP>