email form for many potential recipients

want to get address from small db

[paleolith]

This is probably a very basic question, so I appreciate pointers to relevant information. I tried searching the forums, but the problem is that the critical terms are so common.

A non-profit I want to help has a lot of email links on their web pages, to each member. They know this is a problem but don't have much in the way of resources to fix it. I think the person handling it isn't all that knowledgeable about HTML -- he said something about "we can't maintain an email form for each member", whereas my immediate thought was to drive a single form from a database.

Ideas? At a higher level, my idea would be to put names and addresses in an Access or MySQL database (on the order of a hundred entries). When the user clicks on a link, put up a form containing the name. When the user submits the form, invoke server-side code which looks up the address from the name, and send the email. Actually this is a lot like what "contact an eBay member" does.

It seems like there would be tools for this floating around, but I don't know enough of where to look.

Help?

Edward

[MichaelBluejay]

I don't know of any off-the-shelf tools that would do this, but the programming's not hard. If you can't code it yourself then I'd just hire a programmer for an hour or two.