Access 2000 and Outlook 2003 Question

[Bill J.]

Let me describe the scenario I'm having a problem with.

I'm currently trying to find a way to automatically send
a report generated from Access to individuals through
email. The reports would be tailored to the individual
(ie, preformatted for that individual).

What I want to do is have our data entry folks input any
changes to the report via forms, then be able to send out
the emails to those who need to receive it based on
another table.

So if two people in New Jersey needed to get the list,
and 1 in California it would choose those two (it's based
on state) and all the other 48 states would be ignored.

Any ideas?

Thanks in advance,

Bill J.

 

[John Nurick]

Hi Bill,

There's lots of information about getting Access to send emails at Tony
Toews's email page here: http://www.granite.ab.ca/access/email.htm