I would like someone who has experience writing Outlook message rules to help me implement a rule so that when a message from the automated PACER CM/ECF system comes into my inbox, the following happens:
1.) a script rule will extract following data from PACER CM/ECF system emails (subject line always starts with "Activity in Case"):
*example below shows U.S. District Court for the Northern District of Illinois to illustrate the ecf email format as State (IL = Illinois; for all two-digit state codes, see: http://pe.usps.gov/text/pub28/28apb.htm) and district location (in example ND = Northern District; the other directional district abbreviations are Southern [SD] Eastern [ED] Central [CD] or Western [WD] district of a particular U.S. State.)
Subject: "Activity in Case" O:YY-TY-##### Company XYZ, Inc. vs. Company ABC, LLC notice of motion
The following transaction was entered by LawClerk, FIrstname on 12/21/1899 at 11:26 PM CDT and filed on 12/21/1899.
Case Name: Company XYZ, Inc. vs. Company ABC, LLC
Case Number: O:YY-TY-#####
Filer: Company XYZ, Inc.
Document Number: 123
NOTICE of Motion by John Q. Doe for presentment of motion to compel  before Honorable Judgey P. McJudge on 1/1/1900 at 09:00 AM. (LawClerk, Clerk)
2.) create auto-generated outlook appointments with data from these emails
3.) and log the data from these emails as record entries in either an excel spreadsheet or online SharePoint database. Database would have column fields named like above (RecordNo*, strDocTitle, strDateFiled, strCaseName, strCaseNum, strFIledBy, strDocNum, strDocketText, strDistCourt *) and would log the data from each email into the corresponding fields as individual record entries.
* there are activities that happen, such as discovery answers and requests for production that don't get filed with the courts only exchanged between parties - we still need to keep a record of those as numbered entries, which is why we separately keep track of the docket number as a different field. You could be on entry no 101 in the total number of case activities between parties but only docket no. 66 - docket numbers only count those case activities that are filed with the court.