80333 Email Function

This must be in PHP. I have an article system that allows me to add new articles. 1. When adding a new article I want a check box that says: Send email to members? Yes NO If I click yes and submit. The system should only send the email notification after the article is published not before. So, if article is set up to publish two weeks from now the email should be sent two weeks from now after the article is published. A simple sub routine should work for this. Now, the email sub routine will check the MYSQL database 'active' table to see if the member's 'notify' field is set to '1'. Basically if 'notify' = '1' then send email to that member. The email that will be sent needs to use a .txt template that will have the fields 'fname' 'lname' 'email' 'title'. This will allow me to personalize the email that goes out to the member. This is a very simple modification.