Outlook 2010 subject line ="Authorised" extract to Excel 2010

[iceruby]

Hi there
Using MS Office 2010. Windows 7 platform.

I would like to create a report (eventually automated) if possible.

User to nominate date range. It will be only ever for a specified Outlook folder. Data only to be returned if "Authorised" is text within the subject line. The report is to return

• date / time
• sender
• whole subject line

Is this actually possible?

Appreciate thoughts on where to start.

 

[Andrew Poulsom]

Welcome to MrExcel.

Maybe you can adapt the VBA code here:

http://www.mrexcel.com/forum/excel-questions/345240-export-outlook-excel.html