Hi,

It would be an interesting IF statement that returned both TRUE and FALSE :)

The answer is no or not directly, you can't call a macro to send mail like
that. You would have to test the result of the IF statement using (say) the
worksheet calculate event and send the mail depending on the outcome.

have a look here for using mail

http://www.microsoft.com/office/comm...e-16018026b309

Mike

"Frustrated" wrote:

I am trying to find out if I can create a IF statement that will send out a
email if the IF statement is true or false, but not both?