Automated E-mail Reminder System

My nephew recently set up a web site running Red Hat 2.4.20, Apache 2.0, PHP Version 4.2.2, and MySQL 3.23.54. Now we would like to add an Automated E-mail Reminder System to this site. I need someone to do the following: 1. Help him select and install a good e-mail server. He has SquirrelMail now, but it is not installed. I would like your thoughts on which system to use, and would like your help coaching him through the installation process. He is available via e-mail or by phone Tuesday, Thursday and Saturdays from 10:00am until 6:00pm MST. 2. Develop and install a PHP-based system that would automatically check dates in the MySQL database, and send out alerts or e-mail reminders to individuals or groups of users registered in the system a few hours, days, or weeks prior to those dates based on preferences. 3. Registered users would be able to subscribe or unsubscribe to different types of newsletters and/or alerts. 4. I would also like this system to have a template-based front end that would allow users to upload HTML or text based messages or newsletters with .gif, .png or .jpg graphics, or to select from a list of newsletters or messages already on file. Existing systems and additional features you recommend will be greatly appreciated. ## Deliverables 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. ## Platform Red Hat, Apache 2.x, PHP 4.x, and MySQL 3.x.