Getting number of TODAY mails in various mailboxes in excel cells via VBA

  • Hi

    I'm sorry if this has already been covered in other topics, but I couldn't find what I am searching for.
    As the title suggest, I need to display in cells in my excel file a real time value of all mail arrived TODAY (not before) in some work mailboxes.
    I have access to these mailboxes, I can count the items and put in excel manually, but obviously I would like an automated mean of getting this data.

    There's a way in VBA to grab this data from microsoft outlook?

    Thanks in advance.