How do I...

[David_Estes]

I know how to import e-mails into Access. But I want to have Access to query
itself and send an e-mail. For example...

My master list is..

Jon Doe
Jane Doe
Steve Doe

However in my table are only records for Jon Doe and Jane Doe. I would like
an e-mail to be sent out stating that Steve Doe does not have a record. Is
this possible??!

Maybe I'm asking too much but if someone can help, that would be great.

Thanks.

 

[Douglas J. Steele]

Assuming you've got two tables, one with all three names, and one with only
the two names, you can create a query that lists who's in table1 but not in
table2, and then use that to generate a report that you then e-mail.

Rather than me typing out instructions for all of the steps required, how
about you say what part(s) you don't know how to do?

 

[David_Estes via AccessMonster.com]

You'll have to excuse me, I am new and still learning Access, but...

I know how to create a query, but I don't know how to create one that checks
a table based on another table.

I also do not know how to have Access send an e-mail.

Thanks,
David

Assuming you've got two tables, one with all three names, and one with only
the two names, you can create a query that lists who's in table1 but not in
table2, and then use that to generate a report that you then e-mail.

Rather than me typing out instructions for all of the steps required, how
about you say what part(s) you don't know how to do?

I know how to import e-mails into Access. But I want to have Access to
query

[quoted text clipped - 15 lines]

Thanks.

 

[Douglas J. Steele]

When you go to create a new query, you're given a number of choices. One of
them should be "Unmatched Query Wizard". Choose that, and have it walk you
through the exercise of creating a query that lists all rows that are in
table 1 but not in table 2.

For help with e-mailing from Access, see the Microsoft Access EMail FAQ that
Tony Toews has at http://www.granite.ab.ca/access/email.htm

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

You'll have to excuse me, I am new and still learning Access, but...

I know how to create a query, but I don't know how to create one that
checks
a table based on another table.

I also do not know how to have Access send an e-mail.

Thanks,
David

Assuming you've got two tables, one with all three names, and one with
only
the two names, you can create a query that lists who's in table1 but not
in
table2, and then use that to generate a report that you then e-mail.

Rather than me typing out instructions for all of the steps required, how
about you say what part(s) you don't know how to do?

I know how to import e-mails into Access. But I want to have Access to
query

[quoted text clipped - 15 lines]

Thanks.