A local (Good!) politician in my city handles nearly 200 citizens' emails each day. She has two paid assistants, but they can't handle the pressure altogether, so they've recruited volunteers to sort and summarize the emails for them.
I don't have time for that kind of voluntary work, so I asked one of the assistants if I can help improving the computer systems. She told me that their hardest problem is searching for correspondence history: They need to know if the person has already contacted them, and on which subjects.
They're using outlook for handling emails, which makes searching virtually impossible. They're probably willing to auto-forward to a gmail (or Google Apps) account if necessary, so I can have IMAP and other Google goodies.
How do I solve her problem? I thought of two approaches:
Write a small python script that would retrieve all message headers using IMAP, and store it in a local sqlite table. Another module would group the contacts by sender name, and display a searchable table like this one.
Find some software package that would do the job.