Extracting certain text from Outlook email to an excel

[Tyirie]

Hello, I am trying to extract text from a form email I receive daily. Shown below is what an example of what comes in. I would like to create a column for each of the fields that are in bold below. Also, the emails are not contained in my inbox but in a subfolder of a personal folder. Patch to the folder is xmas pst\Inbox\Alert. Can someone please help me with the VB code?




A Safety Alert has been triggered for the following case:
[TABLE="width: 100%"]
<tbody>[TR]
[TD]Case Number:[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Model:[/TD]
[TD]STRDH550[/TD]
[/TR]
[TR]
[TD]Serial:[/TD]
[TD]8943327[/TD]
[/TR]
[TR]
[TD]Customer:[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Address:[/TD]
[TD]560 Bay Catfish Road
Latta
South Carolina
29565
United States[/TD]
[/TR]
[TR]
[TD]Phone:[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Email:[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Agent ID:[/TD]
[TD]1000314159[/TD]
[/TR]
[TR]
[TD]Department:[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Case Opened: [/TD]
[TD]6/5/2018[/TD]
[/TR]
[TR]
[TD]Escalated:[/TD]
[TD]6/12/2018 5:26 PM[/TD]
[/TR]
[TR]
[TD]Escalation Reason:[/TD]
[TD]Keyword[/TD]
[/TR]
[TR]
[TD]Escalation Severity:[/TD]
[TD]Information Only[/TD]
[/TR]
[TR]
[TD]Keyword:[/TD]
[TD]Blown [/TD]
[/TR]
[TR]
[TD]Escalation Notes:[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]