Advertisement
gn4711

Outlook Change Email Categories

Jun 6th, 2013
186
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub change_email_category()
  2.  
  3.  
  4.     Dim app As Outlook.Application
  5.     Set app = CreateObject("Outlook.Application")
  6.    
  7.     Dim ns As Outlook.NameSpace
  8.     Set ns = app.GetNamespace("MAPI")
  9.     ns.Logon
  10.  
  11.     Dim emails As Outlook.MAPIFolder
  12.     Set emails = ns.GetDefaultFolder(olFolderInbox)
  13.  
  14.     Dim folder As Outlook.MAPIFolder
  15.     Set folder = emails.Folders("10_Work").Folders("BASF").Folders("_old")
  16.    
  17.     Dim obj As Object
  18.     Dim msg As Outlook.MailItem
  19.     For Each obj In folder.Items
  20.         If TypeName(obj) = "MailItem" Then
  21.             Set msg = obj
  22.             msg.Categories = "[10_Work/BASF/_old]"
  23.             msg.Save
  24.         End If
  25.     Next
  26.     Beep
  27.        
  28. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement