The macro call the function to create the html in this line

.HTMLBody = RangetoHTML(rng)

If it can't find the function it is not working
Copy both in a module and run the macro

http://www.rondebruin.nl/mail/folder3/mail2.htm



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



"cjmike" wrote in message ...
Many thanks.

One quick question,

Can you explain this in a little more detail? "Don't forget to copy the
function RangetoHTML in the module."

Many thanks.

"Ron de Bruin" wrote:

Hi cjmike

See my site for example code and example workbooks
http://www.rondebruin.nl/sendmail.htm

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



"cjmike" wrote in message ...
I currently have a macro set up that will e-mail out different worksheets as
e-mail attachements. Is it possible to change this macro to e-mail out as
the body of the e-mail text rather than an attachement?