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.

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




"Eduman" <(E-Mail Removed)> wrote in message
news:79ECF8AF-0481-40B0-AA4E-(E-Mail Removed)...
>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.

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




"Eduman" <(E-Mail Removed)> wrote in message
news:79ECF8AF-0481-40B0-AA4E-(E-Mail Removed)...
>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.



--
----------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4079 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len

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


"Eduman" <(E-Mail Removed)> wrote in message
news:79ECF8AF-0481-40B0-AA4E-(E-Mail Removed)...
>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.



--
----------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4079 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len

Eduman <(E-Mail Removed)> wrote:

>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