vbnewline at strbody is not working. Please help

Hi,

My code, vbnewline at strbody, is not functioning. Please help (refer to code)

PHP Code: 

Private Declare Function ShellExecute Lib "shell32.dll" _
Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, _
ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, _
ByVal nShowCmd As Long) As Long

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    Dim lngResponse As Long
    Dim URL As String, strEmail As String, strSubject As String, strbody As String
    
    If Left(Target.Address, 2) = "$D" Then
        If Target.Value < Range("$E" & Right(Target.Address, 2)).Value Then
            lngResponse = MsgBox("The inventory quantity for this item has dropped below the reorder level. Would you like to reorder this item?", vbYesNo)
            If lngResponse = vbYes Then
                strEmail = Range("$I" & Right(Target.Address, 2)).Value
                strSubject = "New order for " & Range("$F" & Right(Target.Address, 2)).Value & " '" & Range("$B" & Right(Target.Address, 2)).Value & "' items. The remaining " & "'" & Range("$B" & Right(Target.Address, 2)).Value & "' was " & Range("$D" & Right(Target.Address, 2)) & ". This data was capture on " & Format(Now, "dd-mmm-yy, hh:mm AM/PM")
                strbody = "Dear Sir/Madam" & vbNewLine & vbNewLine & "Hi"
                strSubject = Application.WorksheetFunction.Substitute(strSubject, " ", "%20")
                strbody = Application.WorksheetFunction.Substitute(strbody, " ", "%20")
                strURL = "mailto:" & strEmail & "?subject=" & strSubject & "&body=" & strbody
                ShellExecute 0&, vbNullString, strURL, vbNullString, vbNullString, vbNormalFocus
            End If
        End If
    End If
End Sub 


BR
KC

Try vbCrLf before, it is not working as well...

Hi Leith Ross,

With slightly modification on %OAOD, it is working.
"%OA" - is the way for me to create new line.

Many thanks...

BR
KC

Hi Leith Ross,

With slightly modification on %OAOD, it is working.
"%OA" - is the way for me to create new line.

Many thanks...

BR
KC