Edit Subject

See how to edit quickly the subject of received emails.

Last modified: 2016/10/01 | Accessed: 51.823  | #157
◀ Previous sample Next sample ▶
Determine the "identity" of your emails. Set with SAM the sender and the folder folder for sent items with the help of rules.

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
    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
      End If
    End If
  End If
End Sub
ReplyAll ReplyAll
ReplyAll alerts you before unintentionally replying all, or if you are a confidential BCC recipient of the e-mail.
email  Send a message