CRM, Email correspondence stored in database

[MarkW]

All

I'm looking for a simple CRM-type solution that I can quickly build/install and demo here at FQ.

The scenario...
An email query from a Visitor is sent to common mailbox address (e.g. service@example.com)
The email query is received at example.com and stored in database with ticket number reference
An auto response sent to Visitor including ticket number in Subject line
Any one Agent or multiple Agents at example.com can respond to the Visitor's query (response stored in database) with/without email history.
An Agent can refer the query to another Agent (referral stored in database), optionally cc'ing the Visitor, another Agent, etc.
The referee can respond to the Visitor and/or the referer, optionally cc'ing, bcc'ing anyone else.
...

I hope you can see where I'm going. The Visitor's perspective is pretty typical. The example.com perspective is one where a web application and database capture and tie together the complete email correspondence.

Any references as to suitable code libraries/applications out there would be appreciated.

Mark

[oheso]

It sounds like a typical help desk ticketing system that accepts e-mail input. Is it not? There are some FOSS solutions available. I can't recommend any because I haven't tried any, but you should be able to find something quickly with a search on the relevant terms.

[MarkW]

oheso, thanks for your reply.

I've been looking at (http://www.osticket.com/). Has anyone had any experience with this application.

Mark