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 28 29 30 31 32 33 34 35 36 37 38 39
|
Sub mail()
Dim maPj As Object
Dim monMail As Object
Dim MonApp As Object, ns As Object
Dim MonDossier As Object, LesMails As Object
Dim ladate As Date
Dim ladate_2 As String
Dim dat As String
Dim monchemin As String
Dim m As Long
ladate = Feuil10.Range("A7").Value
dat = DateAdd("d", -1, ladate)
ladate_2 = Format(ladate, "ddmmyyyy")
On Error Resume Next: Set MonApp = GetObject(, "Outlook.Application"): On Error GoTo 0
If MonApp Is Nothing Then Set MonApp = CreateObject("Outlook.Application")
Set ns = MonApp.GetNamespace("MAPI")
Set MonDossier = ns.Folders("Structured Derivatives Funds").Folders("Boîte de réception")
MsgBox "Le Dossier est " & MonDossier.Name & " || Nombre de Mails : " & MonDossier.items.Count
Set LesMails = MonDossier.items
For m = 1 To LesMails.Count
If LesMails(m).Subject = "FW: AXA MPS DPI Trade " & dat Then
If LesMails(m).SenderEmailAddress = "Cormac.Stapleton@ipsi.ie" Or LesMails(m).SenderEmailAddress = "Michael.Cima@ipsi.ie" Then
MsgBox "mail trouvé"
Exit For
End If
End If
Next m
End Sub |
Partager