Part of my workflow revolves around hitting certain deadlines. I'd love to have a dialogue pop up when my rules categorize the last piece of the process showing: the number of days between the first email received in "09) Purchase Agreement Received (F2)" and the most recent email received in "00) Final CD (F11)". I already have a rule in place to run the following script to Categorize the email and am not sure how to proceed in VBA to get the desired result. Thank in advance for any light you guys can help shed on this!
Sub FlagFCD(olItem As MailItem)
Dim olAtt As Attachment
If olItem.Attachments.Count > 0 Then
For Each olAtt In olItem.Attachments
If LCase(olAtt.FileName) Like "*.pdf" Then 'If attachment type is PDF
olItem.Categories = "00) Final CD (F11)" 'Categorize Emails with PDF Attachments as 00) Final CD (F11)