Automate email to Excel; Code for Dashboard

Create an input/output, information system to show and describe the financial health of the business with Microsoft Excel and/or related add-ons and include detailed support documentation on its use: 1) Automate passing email from Microsoft Outlook to Microsoft Excel 2) Format this email data to specs (TBA) Requirements Importance Rating 1-------------3-------------5 low neutral very Low Maintenance o Manuel data entry kept to minimum 3 o Automation maximized Secure o Restricted access o Incoming email data obscured but can 4 be referenced in other workbooks Reliable o Checks to find errors against known data 5 Easy to Use o Intuitive user interface 2 o Detailed dashboard to analyze data Easy to Teach o Minimum training time 1 Cheap o Using just Microsoft Excel 2003 4 Networked o Data linked to hard-copy images 4 Documentation o Detailed on usage, tips/tricks, cautions/warnings 3 Need working, business-level prototype ready in two weeks maximum (Deadline A). Tweaks and additional features to be added after 3-day trial. Deadline B will be two weeks maximum after the trial period.