I'm looking to create a simple outlook macro that would dump emails in a specific folder into an excel worksheet. The folder can be called "test" for reference purposes and the excel spreadsheet can be anything.

Outlook will always remain open and the spreadsheet would not be located on a server. This is all local.

Information I would like coming over is the date and the body (possibly the subject).

I've tried this a few different times and have yet to get a working version. I'm using Office 2007.

Any help would be greatly appreciated (appreciated = paypal???) You all are great and very kind for helping out. It is greatly appreciated.