Daniel Klann gave me some code to place an excel range into outlook email
Dim oOutlookApp As Object, oOutlookMessage As Object
Dim rngeSend As Range, strHTMLBody As String
Dim lngRow As Long, lngCol As Long
oOutlookMessage.htmlbody = Range("CERemarks")
If the text in Range("CERemarks") is long it just goes off the page in the email, i.e. it does not wrap text. How do I set it to wrap the text or set margins in the email?
Thanks
Dim oOutlookApp As Object, oOutlookMessage As Object
Dim rngeSend As Range, strHTMLBody As String
Dim lngRow As Long, lngCol As Long
oOutlookMessage.htmlbody = Range("CERemarks")
If the text in Range("CERemarks") is long it just goes off the page in the email, i.e. it does not wrap text. How do I set it to wrap the text or set margins in the email?
Thanks