Outlook – How to get notified of incoming RSS feed items in Outlook 2010

Try visiting the RSS feed in internet explorer and when asked for username and password, click remember so that it stores the credentials.

This should be enough so that next time you use Outlook, the username/password will be remembered.

... I cannot find a password protected RSS feed for me to test it on, but this is how I expect it should work, if anyone has one that I can test on, I will test it out.

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