1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| Sub rappel()
Dim Sh As Worksheet
Dim R As Range
Dim L As Long
Dim msgRAPPEL As String
msgRAPPEL = ""
Set R = ActiveSheet.UsedRange
For L = 12 To R.Rows.Count
If DateValide(R(L, 9), Date, 6) = False Then
msgRAPPEL = msgRAPPEL & Message(R(L, 1), R(L, 2), R(L, 6), R(L, 7), R(L, 8), R(L, 9), R(L, 10))
End If
Next
If Trim("" & msgRAPPEL) <> "" And Sheets("SUIVI ACTIONS").Cells(L, 10).Value <> "CLOTURE" Then
msgRAPPEL = "<table border='1' cellspacing='0' width='100%'>" & MessageTitre & msgRAPPEL & "</Table>"
Mail "RAPPEL ECHEANCES", msgRAPPEL, "aaaaaaa@orange.fr"
End If
End Sub |
Partager