Schedule Emails and Produce Reports

Schedule Emails and Produce Reports This is a web site that will require a lot of work for a long time. I will try someone on a small project, evaluate the work and if satisfied I will award more work. Please see TheBirthdayRegister(dot)com This small project is: To alter a web site that collects double opt-in information into a database, puts information from the database into a layout, and sends emails. This database contains information including Name, Birth Date, Email, Zip Code, and more. Currently a list is pulled from the database and the emails are manually sent upon submission. I want to create an option to schedule the list to be automatically pulled and sent at a time relative to each birth date located in the database. Example: February 19th, I pull a list of all the listings with birth dates in April with a zip code that starts with 782. I schedule an email to be sent 3 days before the birth date. Each day a list is automatically pulled, of all the birth dates that are 3 days away with a 782 zip code, and the email is sent. So, if i tell a batch of emails to send 5 days before the birthdate, it would send 5 days before the birthdates in that batch. So if i pull up a list of all the emails with birthdates in May, I would tell it how many days in advance I want them sent and then every day, it would send some emails. I'm open to suggestions but I'm thinking about a drop down menu with the number of days selected, something like this: 1 2 3 4 5 6 7 8 9 10 15 20 30 45 60 90 Also, I have an Access db and I've been doing manual reports. I need to have reports produce on the website and have some of them automated. I'm open to suggestion but here's what I'm thinking: Manual emailing reports: Manual reports available by merchant(layout), zip code range, and date range. Automatic emailing reports: Automatic Reports sorted by merchant(layout) and listed by specific zips designated to a merchant(layout) Reports will list: Sent Date, Time, Opened?, Layout, Birth Date, Gender, ZipCode, (& Categories? Selected vs Sent) These reports should also be downloadable in Excel and/or txt Web, Page/Site Design, Database, Language Specific, Requirements, ASP.net, Misc (software related), Web Services, SQL Server, Software Related (Includes Websites) Database: SQL Browser Type(s) (all) IE, Firefox Operating System: Windows Server 2003 Control Panel Type: Plesk Server Hosting Environment: Write code for ASP/HTML pages, and manage site with IIS and Enterprise Manager. sql server, language in visual basic or Csharp, [login to view URL], asp not aspx, Will require to sign and return a Confidentiality agreement. Requirements: The seller will analyze the problem and write a solution to the problem. Programming: The programmer will take the requirements and translate them into the language of the computer (and test it). User installation: The installer will move the software from the place it was created (which is called the development or QC environment) to where you will use it (which is called the production environment). The installer then tests the software to make sure that the installation was done properly and completely. As the buyer talks back and forth about the project with the seller, those conversations become the requirements. The seller should create and install the software for an internet web-site: This software runs on a web server and users will access it using their internet browser. Program Functionality: Making the features "work". Create the page layouts modeling another site: [login to view URL] The programmer will perform the physical installation, and unless otherwise stated, will be given all necessary permissions to do so. Legal: 1) I require complete and fully-functional working program(s) in executable form as well as complete source code of all work done (so that I may modify it in the future). 2) Deliverables must be in ready-to-run condition as follows (depending on the nature of the deliverables): 2a) Any website server-side deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. 2b) All other software (including but not limited to any desktop software or software the buyer intends to distribute) must include a software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request (unless specified elsewhere by the Buyer). 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. 3b) No part of the deliverable may contain any copyright restricted 3rd party components (including GPL, GNU, Copyleft, etc.) unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the seller's Seller Legal Agreement. Other Requirements: All deliverables must be uploaded before the deadline(s) for this project...with no exceptions. If this contract makes it impossible for a competent person to do this, then do not start this project...but instead alert of an un-arbitratable, illegal project.