If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Access: Email Automatically?
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? |
#3
|
|||
|
|||
Access: Email Automatically?
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? |
Thread Tools | |
Display Modes | |
|
|