I am trying to do the following...

I don't want to send any attachment...What I would like to do is t
email up to 4 people, all involved in the transaction..

For instance if Range("A1") 0 then

Email these 3 people....

this:

This step has been done, next step is....etc

Is there anyway to get this in the body of the email....Without an
security prompts.....Lastly, I don't know if this is possible, bu
could you add html code for the rest of the body?


thanks for any direction

Jos

--
jhahe
-----------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...fo&userid=2359
View this thread: http://www.excelforum.com/showthread.php?threadid=56715

Hi Josh,

Ron de Bruin has a lot of examples on his site of integrating Excel with
email:

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

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]

jhahes wrote:
I am trying to do the following...

I don't want to send any attachment...What I would like to do is to
email up to 4 people, all involved in the transaction..

For instance if Range("A1") 0 then

Email these 3 people....

this:

This step has been done, next step is....etc

Is there anyway to get this in the body of the email....Without any
security prompts.....Lastly, I don't know if this is possible, but
could you add html code for the rest of the body?


thanks for any direction

Josh

See this example and the CDO page
http://www.rondebruin.nl/mail/change.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Jake Marx" wrote in message ...
Hi Josh,

Ron de Bruin has a lot of examples on his site of integrating Excel with email:

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

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]

jhahes wrote:
I am trying to do the following...

I don't want to send any attachment...What I would like to do is to
email up to 4 people, all involved in the transaction..

For instance if Range("A1") 0 then

Email these 3 people....

this:

This step has been done, next step is....etc

Is there anyway to get this in the body of the email....Without any
security prompts.....Lastly, I don't know if this is possible, but
could you add html code for the rest of the body?


thanks for any direction

Josh