Send Email Reminder from Access after 1 week

  • Thread starter Thread starter PrinceAli
  • Start date Start date
P

PrinceAli

I want to create a follow up reminder in Access that after I created
the record, I want access to send me an email as a reminder to follow
up on that record.
 
I want to create a follow up reminder in Access that after I created
the record, I want access to send me an email as a reminder to follow
up on that record.
Click to expand...

anyone?
 
PrinceAli said:
I want to create a follow up reminder in Access that after I created
the record, I want access to send me an email as a reminder to follow
up on that record.
Click to expand...
anyone?
Click to expand...

Access does not have a "wake myself up after XX amount of time" nor a "wake
myself up at hh:nn on mm/dd/yyyy" feature. If your Access application is
running, it can include code to check a table and see if the time has
arrived to send a reminder... if, however, it is you that is running it,
maybe a big, ugly, garishly colored screen would be a more effective
reminder.

I'm sure it is possible to interact with Windows via some API to schedule a
future event, which could be to start your Access application, with Command
Line control to cause it to execute a particular macro or code. I've used a
number of Windows APIs, but not one for that purpose.

It might also be possible to interact with another application, Microsoft
Outlook perhaps, to set an appointment and reminder. Again, I'm not the
person to ask about interacting with Outlook.

Finally, if your application runs continuously, you can have a form with a
Timer (if you set the Form's Visible property to "No", it won't clutter the
screen) which fires every few seconds to check the time.

Sorry not to be able to be more specific, but those are a "start" to some
possible ways.

Larry Linson
Microsoft Office Access MVP
 
I want to create a follow up reminder inAccessthat after I created
the record, I wantaccessto send me an email as a reminder to follow
up on that record.
Click to expand...

I first would look at how many times a day would I want Access to
remind me. After entering or changing a record, I would set check
option to yes. This will send reminder, if access is still running
then another let say at noon and then another at 3:30 pm. The latter
two would fire off automatically until I view the record and set check
option to no. Outlook would have separate folder for access reminders.
Using Outlooks rules transfer from inbox to reminders folder.
Depending on alerts it may began to seem like juke mail. Access will
check the reminder field two to three times a day to send reminders.
If anything else just send reminder to Outlook task or inbox one.


loringdo:)
 
Back
Top