Thanks Mike,

However what we need to do is for the task\macro to look at a cell, with a
date in it, and then compare it to the current date and if it is older then
current date email the user. This information is all on one sheet.
--
James


"Mike H" wrote:

Hi,

Have a look at the excellent resource


http://www.rondebruin.nl/mail/templates.htm

Mike

"JamesW" wrote:

We have a user who currently uses a simple spreadsheet to list certain types
of enquiries they get. They would like to set up a macro, or such, to enable
an automatic prompt, for example an email, to be sent to a member of staff if
something hasnt been done by a certain time to remind them they need to do
something. The speadsheet deals with multiple enquires assigned to multiple
users.

--
James