Hi Guy's, wonder if you can suggest any method for this one
I am trying to use replace function to find Upper case text and replace with new line (<br>)
Code:
strMsg = "<B><u><i>Your Email Message Received</i></u></B><br>" & Replace(Me.txtMailMessage, UCase(Me.txtMailMessage), "<br><br>")
Debug.Print strMsg
Immediate window
Code:
<B><u><i>Your Email Message Received</i></u></B><br><br><br>
I can use Replace characters / text / numbers etc with newlines but wondered if replacing UCase with new Lines ?
this way, it determines a new sentence