Sub a()
Dim f As Worksheet, l&, c&, rng As Range, t, message$
Set f = ActiveSheet
l = f.Cells(Rows.Count, 1).End(3).Row: c = Cells(l, Columns.Count).End(-4159).Column
Set rng = Range(f.Cells(l, 1), f.Cells(l, c))
t = VBA.Join(Application.Transpose(Application.Transpose(rng)), vbCrLf)
message = t
With CreateObject("Outlook.Application").CreateItem(0)
.To = "prenom.nom@domaine.fr" 'mettre un mail valide
.Subject = "TEST EMAIL": .body = message: .send
End With
End Sub