I am working on a project where I need to parse incoming emails (Microsoft outlook) with a specific subject into an excel file or a Microsoft access table.
You should be able to give Outlook a rule to call a program (your Python one) when the subject matches whatever.
From Python, use the mail module to parse and the windows extensions to access Excel and perhaps Access. There should also be a DBapi extension for accessing Access through sql. Search c.l.p archives, the web, or wait for others to post.
-- http://mail.python.org/mailman/listinfo/python-list
