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:
<tbody>
</tbody>
A Safety Alert has been triggered for the following case:
Case Number: | |
Model: | STRDH550 |
Serial: | 8943327 |
Customer: | |
Address: | 560 Bay Catfish Road Latta South Carolina 29565 United States |
Phone: | |
Email: | |
Agent ID: | 1000314159 |
Department: | |
Case Opened: | 6/5/2018 |
Escalated: | 6/12/2018 5:26 PM |
Escalation Reason: | Keyword |
Escalation Severity: | Information Only |
Keyword: | Blown |
Escalation Notes: |
<tbody>
</tbody>