Access: Email Automatically?

Hello,
Is there a function in Microsoft Access 2000 that can automatically email reports based apon dates in the table.
I created a database that tracks certain information and I found out that the users will need reminders. The only
reminder that I can think of is email. Is it possible?

The table with records has a field combo box that queries a seperate table for user IDs. The User then selects their own user ID and puts in a date in a different date field. The table that the combo box queries has other information like First Name, Last Name and email address.
The user needs a day advance or same day notice that the scheduled record is comming up.
This is where I need Access to automatically generate a report when it sees a scheduled date and a user ID.
We are running Groupwise Email Server and Outlook 2000 clients on Windows 2000. We will soon be going to Exchange 2003.
Now is this possible?

The only way to have Access automatically do this would be to have a form
that is always open with a timer event. The event would go out and see if
any emails needed to be created and would then create them and send them and
mark off that the email has been sent.

You could also have a window or form pop up when a user signs on that lists
all the valid reminders. A button on the form could be clicked to hide it
(but leave it running in the background). A timer event could cause the
report to unhide and pop up every XX minutes if any outstanding reminders
still exist.

Microsoft Outlook's tasks are much better for handling reminders. While you
could do it in Access, you don't bake a cake in a bar-b-que pit.

There are ways to have Access create a reminder in Outlook at the click of a
button. You need to look for articles on Programming Outlook from Access.
They should get you going.






"Iram Alvarez" wrote in message
...
Hello,
Is there a function in Microsoft Access 2000 that can automatically email
reports based apon dates in the table.
I created a database that tracks certain information and I found out that
the users will need reminders. The only
reminder that I can think of is email. Is it possible?