Have a look at this code
Send Word document as email body - Simple Excel VBA which shows how to provide formatted text in the body of the email.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

thanks I have tried replacing the code with the code supplied in the link putting in the email address ect but when i hit the control button it does not work (nothing happens)

thanks I have tried replacing the code with the code supplied in the link putting in the email address ect but when i hit the control button it does not work (nothing happens)