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>
