Bonjour Jean,
à tester,
Public Sub Send_Mail()
If MsgBox("*** PRÊT À ENVOYER LA DEMANDE PAR COURRIEL ***", vbYesNo) = vbNo Then Exit Sub
Dim Sourcewb As Workbook, Destwb As Workbook
Dim OutApp As Object, OutMail As Object
Dim TempFilePath As String, TempFileName As String
Dim strBody As String
'Const FileExtStr As String = ".xlsx", FileFormatNum As Long = 51
With Application
.DisplayAlerts = False
.ScreenUpdating = False
.EnableEvents = False
End With
Set Sourcewb = ActiveWorkbook
Set Destwb = ActiveWorkbook
TempFilePath = Environ$("temp") & "\"
TempFileName = "Modification d'une Pièce SAP " & Format(Now, "yyyy-mm-dd hh.mm.ss")
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=TempFilePath & TempFileName & ".pdf", Quality:= _
xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
strBody = "<H2><B>*** MODIFICATION D'UNE PIÈCE SAP ***</B></H2><H3>" & _
Worksheets("Pièce_à_Modifier").Range("D3").Value & "<H3><B></B></H3>" & _
Worksheets("Pièce_à_Modifier").Range("D5").Value & "<H3><B></B></H3><H3><B></B></H3><H2><B>Merci !</B></H2>"
With Destwb
'.SaveAs TempFilePath & TempFileName & FileExtStr, FileFormat:=FileFormatNum
On Error Resume Next
With OutMail
.To = "moekolisse@gmail.com"
.CC = ""
.BCC = ""
.Subject = "MODIFICATION D'UNE PIÈCE: " & _
Worksheets("Pièce_à_Modifier").Range("C2").Value & _
Worksheets("Pièce_à_Modifier").Range("V1").Value & _
Worksheets("Pièce_à_Modifier").Range("D3").Value & _
Worksheets("Pièce_à_Modifier").Range("W1").Value & _
Worksheets("Pièce_à_Modifier").Range("D5").Value
.HTMLBody = strBody & "<br>" & .HTMLBody
.Attachments.Add TempFilePath & TempFileName & ".pdf"
.display
End With
On Error GoTo 0
.Close savechanges:=False
End With
Kill TempFilePath & TempFileName & FileExtStr
Set OutMail = Nothing
Set OutApp = Nothing
Application.EnableEvents = True
End Sub