Hi

I have a work sheet where we track which jobs are completed during the
work day the sheet is updated via workers punching in their numbers
what i am looking for is a macro that will send an email to
when ever the word "RG Complete" appears in column F.
The email needs to send the subject line corrisponding to column C in
the same row where the word "RG Complete" has appeared in column F.

The email needs to be sent only once not every time the workbook is
opened up.


--
Vlad999
------------------------------------------------------------------------
Vlad999's Profile: http://www.excelforum.com/member.php...o&userid=33586
View this thread: http://www.excelforum.com/showthread...hreadid=553949