Pour changer le sujet:
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 40 41 42 43 44 45 46 47 48 49 50 51 52 53
| Sub Change_Subject()
'---------------------------------------------------------------------------------------
' Procedure : Change_Subject
' Author : Oliv
' Date : 26/11/2018
' Purpose :
'---------------------------------------------------------------------------------------
'
Dim obj As Object
Dim Oitem As Outlook.MailItem
Dim InitSplit, Initiales, i, New_Subject
'choix de l'élément ACTIF
Set obj = Application.ActiveWindow
If TypeOf obj Is Outlook.Inspector Then
Set obj = obj.CurrentItem
Else
Set obj = obj.Selection(1)
End If
If obj.Class <> olMail Then Exit Sub
Dim la_date As Date
Set Oitem = obj
'choix de la date
If Oitem.Sent = True And Oitem.ReceivedByName = "" Then
'MsgBox "Element envoyé"
la_date = Oitem.SentOn
ElseIf Oitem.Sent = False And Oitem.ReceivedByName = "" And Oitem.ConversationIndex <> "" Then
'MsgBox "Nouvelle réponse ou transfert"
la_date = Oitem.LastModificationTime
ElseIf Oitem.Sent = True And Oitem.ReceivedByName <> "" Then
'MsgBox "Element reçu"
la_date = Oitem.ReceivedTime
End If
'Constructions des Initiales
InitSplit = Split(Oitem.SenderName, " ")
Initiales = ""
For i = 0 To UBound(InitSplit)
Initiales = Initiales & UCase(Left(InitSplit(i), 1))
Next i
'Construction du nouveau Sujet
New_Subject = Format(la_date, "YYYYMMdd-HHmm") & "-" & Initiales & "-" & Oitem.Subject
'Affectation du nouveau sujet
Oitem.Subject = New_Subject
Oitem.Save
Set Oitem = Nothing: Set obj = Nothing
End Sub |
Pour enregistrer sur le disque :
https://www.developpez.net/forums/bl...le-disque-msg/
attention il faudra adapter la ligne
NomExport = MyMail.subject & MyMail.CreationTime
Partager