I wrote a VBA routine to go through my inbox and move all email from those domains to my junk folder. It appears below:
Public Sub JunkSpamDomains() On Error GoTo ErrorHandler Dim mailItem As Outlook.mailItem Dim folderInbox As Outlook.folder Dim folderJunk As Outlook.folder Dim i As Long Dim accessor As Outlook.PropertyAccessor Dim strHeaders As String Dim lngOffset1 As Long Dim lngOffset2 As Long Dim lngDomainOffset As Long Dim strFrom As String Dim strDomain As StringConst PR_TRANSPORT_MESSAGE_HEADERS = "http://schemas.microsoft.com/mapi/proptag/0x007D001E"Const strBanned As String = ".trade|.bid|.club|.stream|.date" Set folderInbox = Application.Session.GetDefaultFolder(olFolderInbox) Set folderJunk = Application.Session.GetDefaultFolder(olFolderJunk) For Each mailItem In folderInbox.Items If mailItem.Class = OlObjectClass.olMail Then Set accessor = mailItem.PropertyAccessor strHeaders = accessor.GetProperty(PR_TRANSPORT_MESSAGE_HEADERS) lngOffset1 = InStr(1, strHeaders, vbCrLf & "From: ") + 8 lngOffset2 = InStr(lngOffset1, strHeaders, ">") strFrom = Mid(strHeaders, lngOffset1, lngOffset2 - lngOffset1) lngDomainOffset = InStrRev(strFrom, ".") strDomain = Mid(strFrom, lngDomainOffset) If InStr(1, strBanned, strDomain) > 0 Then mailItem.Move folderJunk End If Set accessor = Nothing Set mailItem = Nothing End If Next mailItem Set folderInbox = Nothing Set folderJunk = Nothing Exit Sub ErrorHandler: Select Case Err.Number Case Else MsgBox "Unexpected Error #" & Err.Number & " " & Err.Description Resume Next End Select End Sub
Press Alt-F11 to open the VBA Editor. Select Insert Module from the menu to insert a new module. Paste this code into the window. You can bind a button on the Quick Access Toolbar (QAT) to this macro. Click the drop-down button on the right of the QAT, and select "More Commands...". Drop the "Choose Commands from:" list and select "Macros". Select "JunkSpamDomains" and click the "Add>>" button. Click the OK button.
After moving message, review the Junk folder to make sure that only spam got moved.
No comments :
Post a Comment
Note: Only a member of this blog may post a comment.