How do I...

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.

.

Relevant Pages

  • Re: How do I...
    ... you can create a query that lists who's in table1 but not in ... Steve Doe ... an e-mail to be sent out stating that Steve Doe does not have a record. ...
    (microsoft.public.access.externaldata)
  • Re: Having Count(*)
    ... So if John Doe ... What you need to do is create another query that looks ... FROM tblMainDataBase ... INNER JOIN Query1 as Q ON T.Patient_ID = Q.Patient_ID ...
    (microsoft.public.access.queries)
  • Re: Get "X" records from one tbl and append to another
    ... You get prompted to create a type of query, ... "Jeff Boyce" wrote: ... Doe John 5556667777 ... Doe Jack 1116667777 ...
    (microsoft.public.access.queries)
  • Re: creating a sort field
    ... Here's the SQL for my query: ... Please provide the SQL ... Jon Doe EH106 12 1 ... in the sort field and so on. ...
    (microsoft.public.access.queries)
  • Re: Get "X" records from one tbl and append to another
    ... Start this by chosing "Create a query by using a wizard"? ... Find the next record in tblRRDExport to be appended to tblCandidates. ... Doe John 5556667777 ... Doe Jack 1116667777 ...
    (microsoft.public.access.queries)