1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
| Sub comptage_ream_pro()
Dim objOutlook As Object, objnSpace As Object, objFolder As MAPIFolder
Dim doss_ream As Integer, b As Integer, date_recep As Date, date_rep As Date, doss_ream_sem As Integer, delai_moy As Double, delai As Double, i As Integer
Set objOutlook = CreateObject("Outlook.Application")
Set objnSpace = objOutlook.GetNamespace("MAPI")
Set objFolder = objnSpace.Folders("860BG S26 Engagements PRO").Folders("Boîte de réception").Folders("RENEGO")
doss_ream = objFolder.Items.Count
b = 2
For i = 1 To doss_ream
With objFolder.Items(i)
date_recep = Format(.receivedtime, "dd/mm/yyyy")
date_rep = Format(.creationtime, "dd/mm/yyyy")
delai = date_rep - date_recep
If date_recep >= Premier_Jour_Semaine_Der And date_recep <= Dernier_Jour_Semaine_Der Then
Sheets("Dossiers Ream").Activate
Cells(1, 1) = "Date de réception "
Cells(1, 2) = "Date de réponse "
Cells(1, 3) = "Delai de réponse"
Cells(b, 1) = date_recep
Cells(b, 2) = date_rep
Cells(b, 3) = delai
b = b + 1
End If
End With |
Partager