Sub test()
Dim OutApp As Object, OutMail As Object, strbody$, FileCell As Range
Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon
Set OutMail = OutApp.CreateItem(0)
'(ici adapter le nom de la feuille et la cellule contenant
'le chemin du fichier
'ex de contenu valide en A1: "D:\Fichier1.xlsm"
Set FileCell = Sheets(1).Range("A1")
With OutMail
.To = "whoever@microsoft.com"
.Subject = "Test"
.Body = "Message de test"
If Trim(FileCell) <> "" Then
If Dir(FileCell.Value) <> "" Then
.Attachments.Add FileCell.Text
End If
End If
.Send 'ou .Display
End With
Set OutMail = Nothing
End Sub