e-mail single sheet using a macro
 

Hi,
Am trying to e-mail a single sheet of a worbook to various people that i
have listed on another sheet in the same workbook. Am using excel 2007. was
using a macro made by a friend that doesnt work in 2007. when activated the
message appears "License for this component not found. you do not etc". can
someone either tell me how to do a macro for use with thunderbird or how to
make my friends macro work?

e-mail single sheet using a macro
 

Check out my site for example code
http://www.rondebruin.nl/sendmail.htm

You can try the CDO code


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Macca01" wrote in message ...
Hi,
Am trying to e-mail a single sheet of a worbook to various people that i
have listed on another sheet in the same workbook. Am using excel 2007. was
using a macro made by a friend that doesnt work in 2007. when activated the
message appears "License for this component not found. you do not etc". can
someone either tell me how to do a macro for use with thunderbird or how to
make my friends macro work?