Outlook Reminders in MS-Access

  • Thread starter Thread starter Charles L. Phillips
  • Start date Start date
C

Charles L. Phillips

Hello,
I inherited an MS-Access 97 database.
The database is used to track inventory.
Is there a way to place reminder in the database to follow-up with customers in the database?


Charles L. Phillips
 
several... :-)
y' have to be more specific

Pieter


Hello,
I inherited an MS-Access 97 database.
The database is used to track inventory.
Is there a way to place reminder in the database to follow-up with customers
in the database?


Charles L. Phillips
 
Charles L. Phillips said:
I inherited an MS-Access 97 database.
The database is used to track inventory.
Is there a way to place reminder in the database to follow-up with customers in the database?
Click to expand...

Using VBA code, with a query which looks at the tickler date based on
todays date. I.e. <= Date(), set a flag in those records as "about
to send emails", loop through the recordset to send the emails, update
the flag as "sent emails", and a sent date. Repeat tomorrow.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Hello,
Each time the company sends a customer a package, I to be reminded
as to follow-up with that customer...
 
Back
Top