Getting data from Outlook into an excel workbook.

[JimmyDodger]

Hi,

Is it possible to use Outlook as a data source for excel?

Specifically, I want to download the following from outlook into Excel.

Message subject.
Message recieved date.

Ideally, also I'd have the folder name as a column, but would be happy with seperate queries.

This would be as automated as possible, i.e. you just click refresh, as would need to run a report every day.

Jim