Read HTML Content from Outlook

Hi

I have a outlook mail which has data in a tabular format in the Mail Body as below. I need to extract the User ID for status where approval is Yes

USER_ID FULL_NAME EFF_ST_DATE LAST_LOGIN MODULE APPROVAL
nmodi Narendra modi 09/09/2016 18:30 12/05/2019 10:15 Govt Yes
dtrump Donald Trump 07/03/2014 18:30 11/26/2019 03:50 OrangeHead Yes
xxiping Xi Xinping 10/29/2019 18:30 12/02/2019 17:23 Dictator Yes
rpappu Raul Pappu 10/29/2019 18:30 12/02/2019 17:23 Mental asylum No
tmaino Tadaka Maino 10/29/2019 18:30 12/06/2019 21:25 Bar Dancer No
However, when I try to read the data from Outlook using Powershell, it reads as below: -

USER_ID

FULL_NAME

EFF_ST_DATE

LAST_LOGIN

MODULE

APPROVAL

dxiaopeng

Deng Xiaopeng

09/09/2016 18:30

12/05/2019 10:15

Dictator

Y

kjung

Kim Jung Sun

07/03/2014 18:30

11/26/2019 03:50

Dictator

Y

xxiping

Xi Xinping

10/29/2019 18:30

12/02/2019 17:23

Dictator

Y

rpappu

Raul Pappu

10/29/2019 18:30

12/02/2019 17:23

Mental asylum

Y

tmaino

Tadaka Maino

10/29/2019 18:30

12/06/2019 21:25

Bar Dancer

Y

How do I extract the User ID for status where approval is Yes?

Thanks

And your code would be? That might help in getting this figured.

When you crosspost the same question at the same time to different forums you should at least post links to the other forums along with your question to avoid people willing to you help making their work twice or more.

https://www.reddit.com/r/PowerShell/comments/h0y8gb/read_html_table_from_outlook/

Thanks