Dim OLapp As Outlook.Application
Dim OLspace As Outlook.nameSpace
Dim OLinbox As Outlook.MAPIFolder
Dim OLmail As Outlook.mailItem
Dim OLbody As String
Dim i As Integer
Set OLapp = CreateObject("Outlook.application")
Set OLspace = OLapp.getNamespace("MAPI")
Set OLinbox = OLspace.getDefaultFolder(olFolderSentMail) 'boite de reception
Set oItem = OLinbox.Items
oItem.Sort " ?[receivedTime]", True 'tri décroissant
i = 0
For Each OLmail In oItem
i = i + 1
If i = 2 Then Exit For
Range("test!a" & i) = OLmail.Subject
Range("test!b" & i) = OLmail.htmlBody
Next