Threading Jira notification emails in Outlook 2010
Solution 1:
The following VBA macro leaves only 1 message per Jira issue in your Inbox. It also deletes messages about Resolved/Closed issues, since I don't need to look at these
' Tools>References: Microsoft VBScript Regular Expressions 5.5, Microsoft Scripting Runtime
Sub RemoveDuplicateJiraKeys()
Dim i As Object
Dim re As New RegExp
Dim m As MatchCollection
Dim d As New Dictionary
Dim act As String ' Commented, Resolved, Updated...
Dim key As String ' e.g. RS-123
re.Pattern = "\[JIRA\] (.*?): \((.*?)\)"
For Each i In Session.GetDefaultFolder(olFolderInbox).Items
' luckily the items come in chronological order
Set m = re.Execute(i.Subject)
If m.Count >= 1 Then
act = m(0).SubMatches(0)
key = m(0).SubMatches(1)
If d.Exists(key) Then d(key).Delete: d.Remove (key) ' same Jira key but older
If act = "Resolved" Or act = "Closed" Then i.Delete Else d.Add key, i
End If
Next i
End Sub
Solution 2:
Outlook 2010 arranges conversations (threading) by subject only. Removing the 'action' from the email subject in JIRA should keep them together in your Outlook inbox. It sounds like you might need to check your Outlook settings. More info available here.