We have an existing MySQL database of users that had a subscribe field for each entry in the database, we are looking for someone to develop a newsletter system in our existing admin control panel. all newsletters will have the same format, with different content each week.
They will include:
3 upcoming events
1 trivia OR poll OR contest that requires participation
links to FB/Twitter
Must be user friendly, WYSIWYG editor preferred to make life easy when preparing newsletters. newsletter should be sent to all entries in the 'users' database that have subscribe = 1 - must also include a link where that week's newsletter can be viewed with the graphics in case emails are not graphic friendly.
All emails will also have to include a url link to be removed from the list with 0 hassle, we insist on being CANSPAM compliant.