Emailing from the database

[Elmobram22]

Hi,

I have a database with my staff in. If they are car drivers I take not of their Insurance and MOT renewal dates. I have built a query that gives me a reminder date ten days before and 5 days after the renewal. I also have an email function that emails my administrators the dates of these. Is there a way of getting the database to email specifically on those dates. I.e. a reminder 10 days before and a check 5 days after? Any help would be greatly appreciated.

Cheers,

Paul

 

[Minty]

Isn't this question really this thread http://www.access-programmers.co.uk/forums/showthread.php?t=269619 again ?

 

[Elmobram22]

Yes I guess it is. I just changed the way I put it cause I realised it wasn't just macro based.

 

[Elmobram22]

Should I mark the other as solved? Or link to this one?