I need a dynamic mailing list add-on for an existing database driven web application:
On 'subscribe to mailing list' user gets served a form with dynamically generated tick boxes for categories and subcategories (read from database).
If user clicks on categories tick boxes, all dependent sub-categories get selected, if user clicks on sub-categories tick boxes, only those get selected.
User fills form First_Name, Last_Name, E_mail.
User toggles html_mail or text_mail option
On user clicking 'subscribe': error check - is at least one select box ticked? - First_Name, Last_Name empty? - correct E_mail format?
Then - details get saved in database
Then - confirmation e-mail gets sent(either text or html) - dynamically generated salutation, you have selected to subscribe to 'dynamically generated categories/subcategories names' To unsubscribe go to 'dynamically generated link to un-subscribe'
If user ever unsubscribes - he gets confirmation of un-subscription sent.
**Admin adds new articles to subcategories or adds new categories or subcategories to existing application - mail list database keeps track of which user should get sent a message about category/sub-category having been updated.
When admin clicks on log-out - message box pops up 'Do you want to send mail now / later'
If now: Application sends dynamically generated salutation, page with all new articles and their hyperlinks subscribed to and footer to unsubscribe go to 'dynamically generated link to un-subscribe'
If later: Application saves settings for a later mail-out
Admin also has a link in admin section where s/he can type a message in a text field and just that gets sent to any of the categories of subscribers.
**If a (sub)category has more than one change/addition, the user should still only get one e-mail with all the additions appended.
There should be a html template and a text template for mail-outs which I could change according to need.
Existing application can be sent to serious contenders.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
Win 2k server IIs5
Access 2000 db