Excel & Lotus Notes

[Phendrena]

Hi there,

I've created a user form and want it to send the data via lotus notes.
I've got the code and i'm happy that it works, however i would like to format the data that it sends.
Can I add html formatting or other formatting options?

This is the section of code that creates the body of the email :

''Create 'Body' of memo
Set objNotesField = objNotesDocument.CREATERICHTEXTITEM("Body")
With objNotesField
 
.AppendText "Date : " & Me.txtDate.Value
.ADDNEWLINE 1
.AppendText "Customer Manager : " & Me.txtCM.Value
.ADDNEWLINE 1
.AppendText "Dealer Number : " & Me.txtDealerNo.Value
.ADDNEWLINE 1
.AppendText "Dealership Name : " & Me.txtDealerName.Value
.ADDNEWLINE 1
.AppendText "Reason For Call : " & Me.cboReason.Value
.ADDNEWLINE 1
.AppendText "Additional Comments : " & Me.txtComments.Value
.ADDNEWLINE 1
End With

Thanks,

 

[Phendrena]

Is anyone able to help me with this query?

Thanks,