I need some assistance with this situation:

I need to create a Data Access Page that allows a person to select an 
employee from a combobox, enter freeflow information in a textbox, and 
click a Send button that will email the information to the Manager of the 
employee.

I have the email part pretty much down in Access by using the command 
button hyperlink address I can open the email and populate the send to and 
subject line. However, I am unsure how to accomplish this with a Data 
Access page. Beyond that I have several managers that have many employees 
and the relationships change 4 times a year. What I'm trying to say here 
is that I need a way to get the manager and employee name into a variable 
and use the variable as the send to and subject lines of the email - not 
to mention I need a way to get the freeflow text into the body of the 
email message.

If anybody has any ideas I would sure appreciate your input.

Kenny