Im doing planning for a training project.  Basically we have a bunch of 
training sessions and now need to book employees on the training.  The 
employee has a choice re the date that he/she wants to attend.

So we want to send an email with the options to the employees and then 
capture the replies in the db.  I believe Access 2007 can do that and i 
watched the demo.

Thats all great but heres the catch.

There are only so many seats available in each session.  Lets call it 30 
seats.  Is there a way that access can send the employee an email to say that 
"The session you have selected is currently full.  Please select another 
session and resend your email"  (or something like that).

Thanks.