I'm doing some pro-bono work for a non-profit and need to cobble together some functionality, preferably without rolling it all myself. Here's the synopsis:
I have a CRM-like system that has Persons and Groups (made up of Persons). I want to set up:
- A dynamic email routing, so [email protected] is routed to the Joe User's email (as defined in the CRM.
- Similarily, [email protected] routes the email to all group members (as defined in the CRM).
- All emails sent to group addresses are added to a threaded forum.
- Emails/forum posts can be held and aggregated into a periodic newsletter if a user prefers.
- New posts are verified via a confirmation email before posting.
- Forum threading and integrity is maintained as users reply to posts whether via email or via the online forum.
Much of this functionality is very similar to standard listserv apps or "groups" sites like Google or Yahoo "Groups", but the need to roll it into an existing php-based portal (Typo3) and have the dynamic email routing creates a unique situation.
Has anyone tackled this type of environment and what tools/tricks did you find helpful?