Look on this site and see if you can't find some code to do that:

Ron de Bruin's site


http://www.rondebruin.nl/index.html


--
Regards,
Tom Ogilvy

"ALLDREAMS" wrote in message
...
is there a way to have a macro copy a cell range and
paste them onto an html email in outlook? I want the
cells' color and formationg to be part of the email. so
far, I can only do it as text, not html..

thanks for your help

--johann