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