Email summary from Outlook to Excel using VBA

  • Hi All,


    I've created a code to fetch email summary from Outlook to excel. It successfully runs on my system.


    This automation is for a shared mailbox, and it was running successfully on the shared mailbox last month with the same file for users, but now for that shared mailbox it's throwing blank result in spite of data being there, or at times there's an error stating invalid date.

    Whereas the same automation is running for my mailbox (Not a shared one)

    Has it to do something with shared mailbox?

    But than the same file was giving results till May.

    Can someone help me out why's the macro behaving this way!