Email distribution list

[michiel]

Does anybody know how to create a email distrubution list in ms Access
thanks

[Pieter Linden]

Re: Email distribution list

michielgs@hotma il.com (michiel) wrote in message news:<4808a0b2. 0311111342.58dd 7bac@posting.go ogle.com>...[color=blue]
> Does anybody know how to create a email distrubution list in ms Access
> thanks[/color]

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.

[michiel]

Re: Email distribution list

pietlinden@hotm ail.com (Pieter Linden) wrote in message news:<bf31e41b. 0311111929.2ac7 20bd@posting.go ogle.com>...[color=blue]
> michielgs@hotma il.com (michiel) wrote in message news:<4808a0b2. 0311111342.58dd 7bac@posting.go ogle.com>...[color=green]
> > Does anybody know how to create a email distrubution list in ms Access
> > thanks[/color]
>
> 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.[/color]

This is a bit to fast for me. Can yoou explain a bit more?

[Pieter Linden]

Re: Email distribution list

michielgs@hotma il.com (michiel) wrote in message news:<4808a0b2. 0311121315.6cde e1d5@posting.go ogle.com>...[color=blue]
> pietlinden@hotm ail.com (Pieter Linden) wrote in message news:<bf31e41b. 0311111929.2ac7 20bd@posting.go ogle.com>...[color=green]
> > michielgs@hotma il.com (michiel) wrote in message news:<4808a0b2. 0311111342.58dd 7bac@posting.go ogle.com>...[color=darkred]
> > > Does anybody know how to create a email distrubution list in ms Access
> > > thanks[/color]
> >
> > 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.[/color]
>
> This is a bit to fast for me. Can yoou explain a bit more?[/color]

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 "relationsh ip" is something
like:

Contact ---1,M---DistributionLis tMembership---M,1---DistributionLis t

(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.Reci pients.Add rs!EMailAddress

....
olkMessage.Send

[TR]

Re: Email distribution list

Look at Micrsoft Knowledgebase article Q178787

http://support.microsoft.com/default.aspx?scid=kb;en-us;178787

for code to create distribution lists using Active Messaging reference.
The code will need editing to be truly useful. I was able to get it to
work ok in Access 2002.


michiel wrote:
[color=blue]
> Does anybody know how to create a email distrubution list in ms Access
> thanks[/color]