VBOffice

Edit Subject

See how to edit quickly the subject of received emails.

Last modified: 2016/10/01 | Accessed: 53.091  | #157
◀ Previous sample Next sample ▶
Reporter Reporter
VBOffice Reporter is an easy to use tool for data analysis and reporting in Outlook. A single click, for instance, allows you to see the number of hours planned for meetings the next month.

With this macro you can edit the subject of an email without having to open it.


tip  How to add macros to Outlook
Public Sub EditSubject()
  Dim obj As Object
  Dim Sel As Outlook.Selection
  Dim DoSave As Boolean
  Dim NewSubject As String
  
  If TypeOf Application.ActiveWindow Is Outlook.Inspector Then
    Set obj = Application.ActiveInspector.CurrentItem
  Else
    Set Sel = Application.ActiveExplorer.Selection
    If Sel.Count Then
      Set obj = Sel(1)
      DoSave = True
    End If
  End If
  If Not obj Is Nothing Then
    NewSubject = InputBox("New subject:", , obj.Subject)
    If NewSubject <> "" Then
      obj.Subject = NewSubject
      If DoSave Then
        obj.Save
      End If
    End If
  End If
End Sub
Category-Manager Category-Manager
With Category-Manager you can group your Outlook categories, share them with other users, filter a folder by category, automatically categorize new emails, and more. You can use the Addin even for IMAP.
email  Send a message