SendObject

[weshader]

I have an Access database that I use as a message board for the employees. On the main form I would like to include a command button that would use the SendObject function to generate an email to the employee that was receiving the message. This could be any number of employees, so I cannot include a specific address in my code. I do not want to leave this part of the code blank either because I would like to have this completely automated. If the "To" argument is blank then outlook prompts you for the address before sending. And if they have to type the address in, people could just send an email with the message in it. But that would not be nearly as fun now would it?



Can someone help me figure this out?

[NTC]

when that command button is clicked - how does it know the correct email address??

your answer probably is that it is somewhere i.e. in some control...

so you have to take that value and write it into the sendobject syntax with vb