Thread
:
Sending an Outlook e-mail due to a condition in a cell..
View Single Post
#
1
Posted to microsoft.public.excel.programming
vee[_2_]
external usenet poster
Posts: 4
Sending an Outlook e-mail due to a condition in a cell..
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
Reply With Quote
vee[_2_]
View Public Profile
Find all posts by vee[_2_]