I have a place on my website (an adult website) that allows users to add their email addresses to receive additional photos via email. Currently, I have simply been collecting the emails into a MySQL DB because this feature has never been setup.
I need someone to setup a verification email process for this. Basically... verify the email address then send another email with the picture attached.
I also have another database of clients which is tied into a pretty basic user interface (so my friend can add client info without getting into phpmyadmin). On this user interface/database I need a few columns added so additional information can be stored.
Finally, I need an email system with a user interface. I have created a visual mock up so it shouldn't be too hard to understand.
I want from this web accessible page to be able to choose from existing databases, apply filters and then based off of the results choose email addresses to email and then a place to write the email and test it.
When sending out emails the system should send no more then 2 or 3 emails a minute. The emails should have a remove from email list option in the header of each email.
A few columns need to be added to an existing database and its user interface.
## Deliverables
Attached is a mockup of the "email system user interface".