writing a macro to identify selected fields

[Guest]

I'm trying to create a multi user database that will automaticly email the
correct person that is selected from a pulldown menue. I've created the
tables that house the person(s) names, their position type(s) and their email
address(s). How do I write a macro(s) that will automaticly identify which
person was selected from the pull down menue, and automaticly select thier
correct email address and send the email with a one time submit button?

Thanks in advance
Nena

 

[Guest]

Nena:

First, use this query as part of your Submit Button: (I am presuming some
names here...)

Select Name, EmailAddr from tblUsers where Name = [Combo1];

As for the email portion, there have been several previous posts, discussing
email. Please do a search and refer to one of them.

Good luck.

Sharkbyte