RE,
Le code fonctionne comme je le voulais excatement.
Derniere question
j'ai déja un code sur le fichier_A comme je l'avais dit comment appeler la deuxieme macro sans incident?
Sub envoi()
'
Dim OutApp As Object
Dim OutMail As Object
derl = Range("A" & Rows.Count).End(xlUp).Row
For i = 2 To derl
If ThisWorkbook.Sheets("Reporting").Range("M" & i).Value = 1 _
And (ThisWorkbook.Sheets("Reporting").Range("N" & i) = 0) Then
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
On Error Resume Next
With OutMail
.To = ThisWorkbook.Sheets("Reporting").Range("L" & i).Value
'.CC = ThisWorkbook.Sheets("Reporting").Range("X3").Value
'.BCC = ""
.Subject = "Accord remboursement Indemnités "
.Body = "Bonjour," & ThisWorkbook.Sheets("Reporting").Range("B" & i).Value & Chr(13) & _
"Voici votre commande de service pour ORANGINA " & Chr(13) & _
"concernant le mois de " & ThisWorkbook.Sheets("Reporting").Range("C" & i).Value _
& " " & ThisWorkbook.Sheets("Reporting").Range("D" & i).Value & Chr(13) & _
"Numéro Commande de Service : " & ThisWorkbook.Sheets("Reporting").Range("J" & i).Value & Chr(13)
'"De la part de : Mr XXXXXXXXXXXXXXXXXXX"
' fichier en pièce jointe
'Feuile de calcul
'.Attachments.Add ActiveWorkbook.FullName
'Fichier du disque dur
'.Attachments.Add "C:\****\****\****\**\NomFichier.Ext"
'Ou
'.Attachments.Add ThisWorkbook.Sheets("Anniversaire").Range("H20").Value
.Send
End With
Range("N" & i).Value = "Oui"
Range("O" & i).Value = Now
On Error GoTo 0
Set OutMail = Nothing
Set OutApp = Nothing
End If
Next i
End Sub