I need a macro or some type of automated system to extract data from a provider of court records I am subscribed to.
Once I log into the site and choose the day I want records for, it provides all court actions on the calender. I then search for the for 2 key phrases: "automatic stay" and "Motion to dismiss". The data is set up in separate paragraphs for each case. I only want information on Chapter 13 bankruptcies. Chapter 7 and 11 are also listed in various separate paragraphs which I am not interested in. Once this info is found, there is a hyperlink for each case which shows a second screen where the "Run Report" button needs pressed.
The final screen has the name and address of the person. Sometimes there is a second paragraph with a second person. I need the names and addresses set into an excel spreadsheet.
This is something I need to run on a daily basis as the court calender is updated.
I have jpegs of the 3 screens, but I don't see a way to attach them to this email.