auto emailing to Outlook

[Mark]

Hi all,

I hope someone will be able to point me into the right
direction. I have a database where I would like to have a
report emailed automactically when certain criteria are
met.

Like, when the user opens the database I could have
the "On Open" property of the switchboard/main-page run a
query to find any records that are lets say, "have
expired". If any records have expired then the report
would be sent out by email. All this would then be in
essence "automatted". One problem I would face is that
this database is on a network with many people, so
sending/emailing the report to the individual (associated
with the record) would be a problem I would think. I have
come across a database that looks to see who has a
database open and it lists the computer number and name of
the person... so, that might be of some kind of help later
on. But is there a way to do all this?

Thanks a bunch!!!

 

[Jim/Chris]

Set up a table with the UserID, Email address and user name
that appears in the record.

On your opening form add a dlookup field based on this new
table that displays the emailaddress(this can be hidden)

Set up a query that that has the data table and the
preveous table just created joining at user name
bring the UserId into the query and add CurrentUser() for
the criteria. Add the expiration criteria into the query.

Create a report from this query.

Create a macro the emails the report. The email address
would come from the first form.
ex.=[Forms]![NameOfForm]![NameOfTextbox]

Add this macro the the on open event of the first form or
to the autoexec macro.

You will have to deal with if there are no records to
email. This also assumes people log into you DB.

If you need anymore help let me know

Jim