Outlook: Macro to Change Case on Text Within Body of Message

[explorer]

I need help configuring a macro in Outlook, The Marco would begin each email reply with "Dear " and automatically insert the name appearing from within the body of the email which is located between the special characters / and =

The name currently resides in the body of the message and consists of all capital letters. I want the first letter of each word of the name to be capitalized and the remainder of the word to be in lower case. The name within the body of the email resides between the characters / and =

For example in the body it shows:

/ JOHN A DOE =

I want the email to start with:

Dear John A Doe,

Thank you in advance! I appreciate your help!

 

[RickXL]

Changing the case to make words begin with a capital letter can be done like this:

Sub Convert()
    Sheet1.Range("A1") = "ABCD EFGH IJKL MNOP"
    Sheet1.Range("A2") = StrConv(Sheet1.Range("A1"), vbProperCase)
End Sub