Project only open to Australian Citizens with an ABN.
I need a locally-hosted application that is capable of monitoring several dedicated Outlook inboxes, recognises action requests in new emails through a set of predefined templates, and then pushes the parsed data into matching fields in an external system.
Core Flow
1. Outlook receives an email → the program checks it against my templates (subject line, body markers, or both).
2. When a template match is found, key values are extracted (e.g. request ID, dates, status, comments).
3. The program connects to the database, locates the relevant record or creates a new one, and writes each value into the correct label/column.
Requirements
• Must run on Windows Server as a service or scheduled task; no cloud components.
• Compatible with current Microsoft 365 desktop Outlook (MAPI or Graph API via local auth is fine).
• Template set should be editable by me without recompiling—JSON, XML or an easy UI works.
• Clear logging: matched template name, data captured, DB action performed, success/error.
• Source code delivered so I can extend it later.
Acceptance
I will sign off when I can:
- Add a new template, send a test email, and see the fields populated correctly in the database.
- Review logs showing each processing step with no unhandled errors.
- Client portfolio to be provided by engaged party to assist with the selection process.
- Opportunity for ongoing projects for the suitable candidate.
Show More