View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
swesterm swesterm is offline
external usenet poster
 
Posts: 4
Default Send email from VBA

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