Web-Based Appointment Scheduler with Outlook Synchronization

I need a fully web-based solution to run a college's advising center. The advising center employees meet with new students and advise them about the appropriate classes to take. This project is PRIMARILY a self-scheduling application for new students to make their own appointments with an appropriate advisor. It must also include at least a basic contact history so that any advisor can review any other advisor's notes about past appointments. There are several key requirements: > Two-way Microsoft Outlook synchronization: When a student schedules an appointment through the web-based system, that appointment must automatically appear in the appropriate advisor's Outlook 2007 calendar. Conversely, if the advisor creates an appointment in their Outlook calendar, that time must automatically become unavailable within the web-based system. > Support for individualized calendars of at least 15 advisors, all of whom can handle only certain types of appointments. > Support for a number of advising types. Example: a new student will select "New Student Advising" and could be scheduled onto ANY advisor's calendar. But if the student selects "Mathematics Advising," only the advisors qualified in Math could be booked for that appointment. > Support for group advising, where multiple students (20 - 50) can be scheduled into the exact same time slot. > Email confirmation to students when they set their advising appointment, as well as an automatic email reminder 24 hours before their appointment. (Ideally, the system could also send SMS reminders 24 hours before the appointment!) > Web-based access for the advisors to make notes about each advising appointment. Primarily, this will be a free-form text entry note system, but the notes must be saved and associated with the student name. (Ideally, the "notes" system would also allow files to be uploaded and "attached" to the appointment notes!) > Web-based access for the advisor to confirm that the student actually attended the advising appointment. If the student did not attend, the system should send the student an automatic missed appointment notice. > Full ability to export all data from the web-based system into a format readable by Excel. This is particularly important. ## Deliverables Advisors must be able to search for past or future appointments through the web site. They must be able to search for such appointments using any criteria they choose. When a student makes an appointment, they must provide: 1. Legal first name (free form text) 2. Legal last name (free form text) 3. Email address (field must validate that entry includes @ sign and . ) 4. Best telephone number (field must validate correct phone number format of exactly 10 digits) 5. Intended major (student will select from a provided list) The site must support the addition of other fields at a later time. I will likely add more fields as we develop this site. This site must be secure.