By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,122 Members | 927 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,122 IT Pros & Developers. It's quick & easy.

Button to Send an Email to Group(s)

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
we******@yahoo.com (Jeff West) wrote in message news:<55**************************@posting.google. com>...
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


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
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.