No need for any of us to reinvent the wheel when Ron has already done all
the hard work.

Besides I think you might appreciate the exercise....

(No offense meant)...

--
steveB

Remove "AYN" from email to respond
"swesterm" wrote in message
...
While I appreciate the help, is there someone out there who can answer
this
WITHOUT forwarding me to someone's webpage? I am sure this is just a
fewlines of code.

Activeworkbook.sendmail would work if i wanted to attach the workbook -
BUT
I don't. I just want to send an email with a Subject line and THAT IS IT

Thx!

"Norman Jones" wrote:

Hi swesterm,

See Ron De Bruin's extensive email coding examples at:

http://www.rondebruin.nl/sendmail.htm

---
Regards,
Norman



"swesterm" wrote in message
...
I don't want to send a workbook. My coding is all set. I have the
macro
run, and if a certain value is reached, then I want to send an email
out
to 2
people. Simple as that. But I can't figure out the coding. Will
someone
PLEASE answer me using my examples listed below?

I want the subject of the email to say = "Value has been reached"
I want to send the email to = " AND "
I don't want any attachments OR body text.
Just send it to certain people AND a subject heading.

Can someone please help WITHOUT directing me to someone else's website?

Thx