Modifications on PHP website

The client has this website [login to view URL] and he would like 2 modifications/additions done to it. The website is a deal/product aggreggator, it reads one XML that contains all data for every category and automatically puts it in the correct categories. Its built on PHP and mySQL. The first will be to change the design, so I will offer you the current design in PSD form, so you can do a new one while keeping the same proportions, hopefully this will make slicing a bit easier. The second is that he want to create a newsletter feature. Currently, when a user visits the first time he sees a lightbox that lets him enter his email, city and deal preference (i.e. food, spa etc). This is already recorded in the database. He want a simple newsletter capability (We will send you a newsletter from a similar website so we will take the design from there) that will let me choose which city to send newsletter to (so all users with city = 1 will be selected), step 2 will be to select the dealsites which we will select with tickboxes, step 3 will be to show ALL deals that come from these dealsites (3 columns: column 1 will be the order in which they will appear in the newsletter, column 2 will be the dealsite, column 3 will be the full title of deal) so we can select with tickbox which deals we want to send. On the top of this page (step 3 page) will be the Email Subject field, where we will enter the subject. Step 4 will be the send feature. We will be using a cron job to let me select the time of day (and program it for the future) to send the newsletter. Feel free to ask me anything in advance. Obviously all source code will be given to you, however this will be setup as a completely new website, with new domain etc. Please read the project first and write the word "Understood". Also write your steps and suggestions to complete the project with a short description of what you understood.