Hi

Please help:

I have a worksheet with a formula the changes a cell(J24) to either
"ORDER" or "OK" ...i have used vb script with
modifications:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Range("J24"), Target) Is Nothing Then
If Target.Value = "ORDER" Then
Mail_with_outlook
End If
End If
End Sub

all works fine if i type ORDER into the cell(J24)..the e-mail is
generated...but when the formula generates the result ORDER based on
the formula...no e-mail is generated.

I suspect this does not work beacuse of the Change event....but i
don't know what else to use...as i am new to vb.

Thanks For your time