Sub mail()
Dim mail As Variant
Dim strpath As String
strpath = CurDir & "\" & ThisWorkbook.Name
htmlCorps = "<body><p><font face=arial>" & Range("Mailsauto!A2")
htmlCorps = htmlCorps & "<BR><BR>Lien: <a href='file:\\" & strpath & "'>" & strpath & "</a>"
Set mail = CreateObject("Outlook.Application") ' creation objet mail outlook
With mail.CreateItem(olMailItem)
.Subject = Range("Mailsauto!A2") & Range("C4")
.To = Range("MailConstateur_de_la_NC")
.CC = Range("Listenomsemail!mailQA")
.htmlbody = htmlCorps
.Display
'.Send
End With
End Sub