Sub ObjetDate()
Dim oMail As MailItem
Dim myFolder As Folder
Dim myOlApp As Outlook.Application
Dim myNamespace As NameSpace
Dim StLeft As String
Set myOlApp = Outlook.Application
Set myNamespace = myOlApp.GetNamespace("MAPI")
Set myFolder = myNamespace.GetDefaultFolder (olFolderInbox)
For Each oMail In myFolder.Items
oMail.Subject = Replace(oMail.Subject, "RE: ", "")
oMail.Save
oMail.Subject = Replace(oMail.Subject, "Re: ", "")
oMail.Save
oMail.Subject = Replace(oMail.Subject, "TR: ", "")
oMail.Save
oMail.Subject = Replace(oMail.Subject, "TR :", "")
oMail.Save
oMail.Subject = Replace(oMail.Subject, "Fwd: ", "")
oMail.Save
StLeft = Mid(oMail.ReceivedTime, 7, 4) & Mid(oMail.ReceivedTime, 4, 2) & Mid(oMail.ReceivedTime, 1, 2)
If Left(oMail.Subject, 8) <> StLeft Then
If IsNumeric(Mid(oMail.Subject, 1, 1)) = True And _
IsNumeric(Mid(oMail.Subject, 2, 1)) = True And _
IsNumeric(Mid(oMail.Subject, 3, 1)) = True And _
IsNumeric(Mid(oMail.Subject, 4, 1)) = True And _
IsNumeric(Mid(oMail.Subject, 5, 1)) = True And _
IsNumeric(Mid(oMail.Subject, 6, 1)) = True And _
IsNumeric(Mid(oMail.Subject, 7, 1)) = True And _
IsNumeric(Mid(oMail.Subject, 8, 1)) = True Then
If Mid(oMail.Subject, 9, 1) = " " Then
oMail.Subject = Mid(oMail.Subject, 10)
oMail.Save
Else
oMail.Subject = Mid(oMail.Subject, 9)
oMail.Save
End If
oMail.Subject = Mid(oMail.ReceivedTime, 7, 4) & Mid(oMail.ReceivedTime, 4, 2) & Mid(oMail.ReceivedTime, 1, 2) & " " & oMail.Subject
oMail.Save
Else
oMail.Subject = Mid(oMail.ReceivedTime, 7, 4) & Mid(oMail.ReceivedTime, 4, 2) & Mid(oMail.ReceivedTime, 1, 2) & " " & oMail.Subject
oMail.Save
End If
End If
Next oMail
End Sub
Partager