E-mail Rich Text Format

[burakorhan23]

Dear All ,

I use IBM lotus mail software. I create a macro which get some data from excel and sent to related people. However I couldn't send data with "richtext" format. Therefore mail content is really messy.

How can I send e-mail with "richtext format" . Please help me.

You can find my data copy to mail code in below.




Set rnBody = ActiveSheet.Range(Cells(7, 8), Cells(lastr, 14)) '

rnBody.Copy
Set Data = New DataObject
Data.GetFromClipboard

 

[burakorhan23]

I need your valuable feedback

 

[burakorhan23]

I'm waiting your feedback my friends.

 

[burakorhan23]

Please I need your support.