السلام عليكم
إستبدل هذا السطر في الكود
Mail.TextBody = "RENT EXPIRED FOR MR" & " " & .Cells(i, 1).Text & " " & "ON DATE" & " " & .Cells(i, 6).Text & " " & "AFTER" & " " & .Cells(i, 7).Text & " DAYS" & " " & "AMOUNT IS" & " " & .Cells(i, 3).Text
بهذا
Mail.TextBody = "RENT EXPIRED FOR MR" & " " & .Cells(i, 1).Text & " " & "ON DATE" & " " & .Cells(i, 6).Text & " " & "AFTER" & " " & .Cells(i, 7).Text & " DAYS" & vbNewLine & " " & "AMOUNT IS" & " " & .Cells(i, 3).Text