newsletter system - repost

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: 1 advertisement 3 upcoming events 1 article 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. login system is already in place, admin panel is already in place, no signup feature needed, should use EXISTING database, again where subscribe = 1