Email Reporting System - Database Integration

We require a solution that will allow us to send our customers to several types of emails on both an automated or manual basis. Initial email types include: > 1. **Welcome: **Sent upon activation of a new account > 2. **Monthly Statement:** Sent at the end of every month with detailed transaction history driven from a database > 3. **Come Back:** Sent to users who have not used our service in the last 30 days Each of these email types needs to be configurable on a regional basis (i.e. the Welcome email to be sent to European customers needs to be different than those sent to North American customers. We are open to configuring and/or customizing an existing 3rd party solution (i.e. Crystal, email marketing program etc.) ## Deliverables Whether a 3rd party software solution is used, or a custom application is built, basic requirements include 1. A configurable set of database tables that describe email templates including: - The HTML source to send - The email type (i.e. Welcome / Monthly Statement etc.) - A SQL Statement describing the users that this email will be sent to - The geographical regions the email applies applies to 2. A language to embed the output of one or more queries in the email source 3. Unsubscribe and bounce support. 4. A console application that allows: -The list of subscribers to be previewed -A test message to be sent prior to running the entire batch A nice to have, and potential future enhancement would include the ability to schedule delivery for certain types of emails. This is not a requirement for the intial project.