E-mail Rich Text Format

burakorhan23

New Member
Joined
Apr 29, 2018
Messages
9
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
 

Forum statistics

Threads
1,082,500
Messages
5,365,935
Members
400,863
Latest member
kimtid

Some videos you may like

This Week's Hot Topics

Top