How do I get the database to notify me with an email???

[TYLER_DURDEN]

I need my database to send me an email notifying me of certain individuals five days before a scheduled appointment. Basically, I want to receive an email stating the names of individuals that will have an appointment 5 days from now. I currently have a query setup with that will automatically build my dates from the first appointment, but I need that notification 5 days prior to each appointment. Do I make sense? If so, can anyone help me???

TD

 

[mission2java_78]

Use criteria in your query to get the correct entries. For instance,

now() - 5

date() + 2

etc...

Then use the outlook object model to send your email

Dim objEmail as Outlook.MailItem

Jon

 

[mark curtis]

Why dont you just run a daily report to provide this information?

If you want automated emailing then you start to get into the realms of code, which can be tricky.