email function

[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

 

[Stan Scott]

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

 

[Dave the Man]

erm.... I am a complete novice when it comes to VBA. Can you take m
through how I would do it please?
:confused