Email notification from database?

[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

 

[Mile-O]

Use the SendObject macro to send your query.