Automating Task within Excel To Send Emails

[JamesW]

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 hasn’t been done by a certain time to remind them they need to do
something. The speadsheet deals with multiple enquires assigned to multiple
users.

 

[Mike H]

Hi,

Have a look at the excellent resource


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

Mike

 

[JamesW]

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.

 

[Ron de Bruin]

hi James

See the second example on this page
http://www.rondebruin.nl/mail/folder3/message.htm

 

[JamesW]

Ron,

Many thanks for the example. I will give that a go.

Regards