Sub EssAi()
Dim DerLig As Long, i As Integer
DerLig = ActiveSheet.Cells(Rows.Count & 1).End(xlUp).Row
For i = 1 To Range("A1:A") & DerLig
ActiveWorkbook.SendMail Recipients:=Range("A" & DerLig), _
Subject:="Test envoi classeur", _
ReturnReceipt:=False
Next i
End Sub