Get Outlook Mail Item Data to Excel

[smartbuyer]

Hi All,

I am familiar with VBA but have yet to work with VBA in Outlook. So I was hoping to get some assistance/direction to start with.

My goal is to be able to track/retrieve some data from an MS Exchange (Shared) inbox

To have a user-initiated tool via VBA in excel or via outlook and loop through the inbox mail items to retrieve the following information

• Send On Date
• Mail Subject
• Category (name)

We have more than one MS Exchange Shared Mailbox so I would want the ability to specify which Inbox the user would like to view.

Appreciate your help in advance!!!