Hi Claytocb,
To have a formatted body, you'd need to set the BodyFormat property to Rich Text or HTML. See:
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx. As shown in the link, for HTML you can simply add the relevant HTML tags to your code. For RTF, however, the Outlook Object Mode doesn't actually provide any support for writing the formatted message body. For that, you'd need to use a 3rd-party API, such as
Outlook Redemption, which provides the RTFBody property, thus make it possible to write rtf values in to your message body. See:
http://www.dimastr.com/redemption/.
An alternative approach is to use Word as your email editor, which gives you access to its formatting abilities - and the ability to do such things as copying from Excel and pasting via Paste Special in Word.
PS: When posting code, please use the code tags. They're on the 'Go Advanced' tab.