creating email groups

[Guest]

I am trying to create a way to keep and update yearly school-wide contact
information that includes student and parent information along with email
addresses. I would then like to use querries to extract certain email
addresses to email an announcement to. The thing is that we don't use
Outlook at our school. We use an SMTP mail server though. I looked at the
different posts but couldn't find a way to do this that didn't mention
Outlook. Should we use Access or is there another way? We would like to
increase grade levels each year (+1 to existing) and add the new Kindergarten
students and drop the leaving 5th grade students. In our email program, we
would have to regroup every year.

 

[Pieter Wijnen]

If your email program has an API you can use that
Dundas used to have a freebie & there's bound to be a lot other free and/or
cheap solutions available
CDO is the standard windows API for dealing with mail - the only problem is
that newer versions of it nag you wether you are really sending (or is it a
virus/spam program impersonating you) & can be set up to use Outlook
Express - search msdn for usage

Pieter

 

[Pieter Wijnen]

If your email program has an API you can use that
Dundas used to have a freebie & there's bound to be a lot other free and/or
cheap solutions available
CDO is the standard windows API for dealing with mail - the only problem is
that newer versions of it nag you wether you are really sending (or is it a
virus/spam program impersonating you) & can be set up to use Outlook
Express - search msdn for usage

Pieter

I am trying to create a way to keep and update yearly school-wide contact
information that includes student and parent information along with email
addresses. I would then like to use querries to extract certain email
addresses to email an announcement to. The thing is that we don't use
Outlook at our school. We use an SMTP mail server though. I looked at
the
different posts but couldn't find a way to do this that didn't mention
Outlook. Should we use Access or is there another way? We would like to
increase grade levels each year (+1 to existing) and add the new
Kindergarten
students and drop the leaving 5th grade students. In our email program,
we
would have to regroup every year.

--

 

[Pieter Wijnen]

Sorry, need to read more carefully
The way my teacher friend does it is using 'Class of' instead of Grade
Then You can leave everything as is & calculate the 'Grade' based on the
current year...

Pieter

I am trying to create a way to keep and update yearly school-wide contact
information that includes student and parent information along with email
addresses. I would then like to use querries to extract certain email
addresses to email an announcement to. The thing is that we don't use
Outlook at our school. We use an SMTP mail server though. I looked at
the
different posts but couldn't find a way to do this that didn't mention
Outlook. Should we use Access or is there another way? We would like to
increase grade levels each year (+1 to existing) and add the new
Kindergarten
students and drop the leaving 5th grade students. In our email program,
we
would have to regroup every year.

--

 

[Tony Toews]

I am trying to create a way to keep and update yearly school-wide contact
information that includes student and parent information along with email
addresses. I would then like to use querries to extract certain email
addresses to email an announcement to. The thing is that we don't use
Outlook at our school. We use an SMTP mail server though.

Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm