The following will check a date in a message body that the cursor is either in, or immediately to the left or right of (without a space), and will change the date if necessary to tomorrows date (here using the short date format - change the format as required).
Sub CheckDate()'Graham Mayor - http://www.gmayor.com - Last updated - 26/11/2016
Dim oRng As Object
On Error GoTo ErrHandler
If TypeName(ActiveWindow) = "Inspector" Then
If ActiveInspector.IsWordMail And ActiveInspector.EditorType = olEditorWord Then
Set oRng = ActiveInspector.WordEditor.Application.Selection.Range
oRng.movestartuntil Chr(32), -1073741823
oRng.moveenduntil Chr(32) & Chr(13) & Chr(11) & "!:;?,."
MsgBox oRng.Text
If IsDate(oRng.Text) Then
If Not CDate(Date) = Date + 1 Then
oRng.Text = Format(Date + 1, "Short Date")
End If
End If
MsgBox oRng.Text
End If
End If
lbl_Exit:
Exit Sub
ErrHandler:
Beep
Resume lbl_Exit
End Sub