单元格文本被截断为大约 1390 个字符

我在这里修改了代码 - https://www.extendoffice.com/documents/excel/3560-excel-send-personalized-email.html

如果单元格中的文本很长，则会被截断。

我尝试将应用程序时间值增加到 0.20，但没有任何效果。它在同一点被截断了。

#If VBA7 And Win64 Then
    Private Declare PtrSafe Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" ( _
                         ByVal hwnd As LongPtr, ByVal lpOperation As String, _
                         ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, _
                         ByVal nShowCmd As Long) As LongPtr
#Else
    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
#End If

Sub SendEMail()
    Dim xEmail As String
    Dim xSubj As String
    Dim xMsg As String
    Dim xURL As String
    Dim i As Integer
    Dim k As Double
    Dim xCell As Range
    Dim xRg As Range
    Dim xTxt As String
    On Error Resume Next
    xTxt = ActiveWindow.RangeSelection.Address
    Set xRg = Application.InputBox("Please select the data range:", "navneesi", xTxt, , , , , 8)
    If xRg Is Nothing Then Exit Sub

    For i = 1 To xRg.Rows.Count
    '       Get the email address
        xEmail = xRg.Cells(i, 1)
    '       Message subject
        xSubj = "Validation Assignment"
    '       Compose the message
        xMsg = ""
        xMsg = xMsg & "Validation Assignment: " & vbCrLf & vbCrLf
        xMsg = xMsg & " Order ID: " & xRg.Cells(i, 2).Text & vbCrLf
        xMsg = xMsg & " Marketplace ID: " & xRg.Cells(i, 3).Text & vbCrLf
        xMsg = xMsg & " Order Day: " & xRg.Cells(i, 4).Text & vbCrLf
        xMsg = xMsg & " Seller ID: " & xRg.Cells(i, 5).Text & vbCrLf
        xMsg = xMsg & " Product Code: " & xRg.Cells(i, 6).Text & vbCrLf
        xMsg = xMsg & " Item Name: " & xRg.Cells(i, 7).Text & vbCrLf
        xMsg = xMsg & " Defect Source: " & xRg.Cells(i, 8).Text & vbCrLf
        xMsg = xMsg & " Defect Day: " & xRg.Cells(i, 9).Text & vbCrLf
        xMsg = xMsg & " Defect Text: " & xRg.Cells(i, 10).Text & vbCrLf
        
    '       Replace spaces with %20 (hex)
        xSubj = Application.WorksheetFunction.Substitute(xSubj, " ", "%20")
        xMsg = Application.WorksheetFunction.Substitute(xMsg, " ", "%20")
    '       Replace carriage returns with %0D%0A (hex)
        xMsg = Application.WorksheetFunction.Substitute(xMsg, vbCrLf, "%0D%0A")
    '       Create the URL
        xURL = "mailto:" & xEmail & "?subject=" & xSubj & "&body=" & xMsg
    '       Execute the URL (start the email client)
        ShellExecute 0&, vbNullString, xURL, vbNullString, vbNullString, vbNormalFocus
    '       Wait two seconds before sending keystrokes
        Application.Wait (Now + TimeValue("0:00:02"))
        Application.SendKeys "%s"
    Next
End Sub