View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
STEVE BELL STEVE BELL is offline
external usenet poster
 
Posts: 692
Default Send Email from Macro VBA Excel

Check this site, Ron has some good stuff

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

--
steveB

Remove "AYN" from email to respond
"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