Email excel as body rather than attachment

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

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" <[email protected]> wrote in message news:[email protected]...
> 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
>
>