email function

  • Thread starter Thread starter Dave the Man
  • Start date Start date
D

Dave the Man

Hi,
Is there a way to send an email depending on the outcome of a functio
in Excel? So for example,

=IF(a1=1,*send email*,"")

Any ideas? Thanks
 
Apples and oranges. To cause a behavior like sending mail, you have to kick
it off from a VBA routine. You might try setting up an event (calculation?)
that will then run the routine.

Stan Scott
New York City
 
erm.... I am a complete novice when it comes to VBA. Can you take m
through how I would do it please?
:) :confused
 
Back
Top