Dim ol As Object, myItem As Object
Dim Attachement As String
Dim strBody As String
Set ol = CreateObject("outlook.application")
Set myItem = ol.CreateItem(olMailItem)
myItem.to = ThisWorkbook.Sheets("Mail").Range("A1")
myItem.Subject = ThisWorkbook.Sheets("Mail").Range("A2")
strBody = ThisWorkbook.Sheets("Mail").Range("A3")
myItem.Body = strBody
Set myAttachments = myItem.Attachments
Attachement = ThisWorkbook.Path & "\" & ThisWorkbook.Name
If Attachement = "" Then GoTo e_Send
myAttachments.Add Attachement
e_Send:
myItem.Send
Set ol = Nothing
Dim ol As Object, myItem As Object
Dim Attachement As String
Dim strBody As String
Set ol = CreateObject("outlook.application")
Set myItem = ol.CreateItem(olMailItem)
myItem.to = ThisWorkbook.Sheets("Mail").Range("A1")
myItem.Subject = ThisWorkbook.Sheets("Mail").Range("A2")
strBody = ThisWorkbook.Sheets("Mail").Range("A3")
myItem.Body = strBody
e_Send:
myItem.Send
Set ol = Nothing
myItem.To = ThisWorkbook.Sheets("Mail").Range("A1")
myItem.To = "prenom.nom@societe.com"