Send mail to specified mail addresses if a situation qualifies

[mohitmahajan]

Hi,

I have checked the entire site and could not get a solution - so am posting this query.

I am making a MIS and want that if the a particualr situation(s) is met then mail should go to concerned people.

There are several sheets in the workbook with one sheet containing the master data (data from which reports will be taken out).

One example of the MIS info is: Lets assume that there are 50 different types of tasks that are done by the team. For each task there is an expected number of hours of work that should come in a month. In case there is a change of +/- 10% in the work received for this task / any task then a mail should go out to pre-defined process owners.

Similarly there are other tabs containing more information where I want the mails to go out to pre-defined people for each tab in case a condition is not met...
Pls remember I do not know VB O(...

Any help will be appreciated....

Thanks,

Mohit

[Vlad999]

Try this site http://www.rondebruin.nl/mail/change.htm
Sorry I cant help you more but im still a noob myself

[mohitmahajan]

...will check this out and let you know...am waiting for my friend to come in after the leaves.

[mohitmahajan]

I read thru the link and it seems that I should have mentioned something else also - we are using Lotus Notes. So, pls suggest how to proceed.