Read HTML Content from Outlook

Welcome Forums General PowerShell Q&A Read HTML Content from Outlook

Viewing 2 reply threads
  • Author
    Posts
    • #234856
      Participant
      Topics: 3
      Replies: 1
      Points: 11
      Rank: Member

      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

    • #235093
      Participant
      Topics: 6
      Replies: 104
      Points: 487
      Helping Hand
      Rank: Contributor

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

    • #235096
      Participant
      Topics: 3
      Replies: 431
      Points: 1,533
      Helping Hand
      Rank: Community Hero

      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

Viewing 2 reply threads
  • You must be logged in to reply to this topic.