westwas1@yahoo.com (Jeff West) wrote in message news:<55448e6a.0310201434.6b5ecd3d@posting.google. com>...[color=blue]
> Greetings all,
> I'm not a developer (not even close) but have been teaching myself
> Access lately and would like to ask the group for some help.
>
> I've recently created a employee contact database for my office and
> each contact in the table is classified into the type of contact they
> are. Each contact can have more than one of these classifications.
>
> What I would like to do is create a button on our entry form that you
> would be able to click to, say, send an email to all our Blue Clients.
> Another button could send an email to all our Red Clients. It would
> open up the user's default email application (yes, VIM protocol) and
> would dump the email addresses of all the contacts in that
> classification into the TO: line.
>
> I've been able to find information and have created buttons that would
> attach a report from your database (DoCmd.SendObject). But I can't
> seem to find out how to do this one.
>
> Any (simplified) assistance would be greatly appreciated.
>
> Thanks!
> ~Jeff West
> Seattle, WA[/color]
You'd need 3 tables. Client--<ClientGroup>---Group
Then you could do something like use the code from mvps.org to
concatenate all the ClientGroup record values into a single field in a
query, and send the e-mail to that list. Then you could pass that
function's return value to the SeondObject command, and it would do
the mailing for you. Here's the link:
http://www.mvps.org/access/modules/mdl0004.htm 
Button to Send an Email to Group(s) 
