mi*******@hotmail.com (michiel) wrote in message news:<48**************************@posting.google. com>...
pi********@hotmail.com (Pieter Linden) wrote in message news:<bf**************************@posting.google. com>... mi*******@hotmail.com (michiel) wrote in message news:<48**************************@posting.google. com>... Does anybody know how to create a email distrubution list in ms Access
thanks
Yes.
Oh, you mean you wanted an answer other than yes or no?
Recipient----(1,M)--MemberOfGroup---(M,1)---Group Then just use a
query to retrieve all the members of the group, loop through the
recordset, append all values to a text string, pass to your e-mail
program, and you're done. Cinch.
This is a bit to fast for me. Can yoou explain a bit more?
This is really simple. Think of Outlook. You have Contacts and they
can all have addresses. You can create Distribution Lists, which are
just named lists of Contacts. So the "relationship" is something
like:
Contact ---1,M---DistributionListMembership---M,1---DistributionList
(each contact can belong to one or more Distribution Lists, and each
DL can contain one or more contacts.)
So when you want to mail something to a group of people, you choose
the Distribution List... and it pulls all the addresses and resolves
them for you. But this is the part you'd have to do. Then you'd have
to do the concatenating fun... There's code at
www.mvps.org to do
that. Look up fConcatChild. That would give you a semi-colon
delimited list, and you could use it as a recipient list for your
e-mail. If you're using Outlook, you could just skip that and append
the members of the list to the Recipients collection of the message
you're sending.
olkMessage.Recipients.Add rs!EMailAddress
....
olkMessage.Send