Hi, I have an email which with the following content. I would like to extract
“First Name, Last Name, ARD Name, Password, Email Address” to a Google sheet.
+++++++++++++Begin+++++++++++++
From: HR Department <tester@blueforestintl.com>
Date: Mon, Jan 23, 2023 at 12:57 PM
Subject: Ticket Assigned - Connect Report - ADR Staff Added - Blue Forest International (Department)
To: <tester@blueforestintl.com>
Connect Report - ADR Staff Added - Blue Forest International (Department)
Locker Connect Message from Blue Forest International (Department).
Results: (plain text results below table)
First Name Last Name ADR Name Password Email Address
Active Directory1 adirectory1 Pass123 adirectory1@blueforestintl.com
Active Directory2 adirectory2 Pass123 adirectory2@blueforestintl.com
Active Directory3 adirectory3 Pass123 adirectory3@blueforestintl.com
Active Directory4 adirectory4 Pass123 adirectory4@blueforestintl.com
First Name, Last Name, ADR Name, Password, Email Address
Active,DIRECTORY1,adirectory1,Pass123,adirectory1@blueforestintl.com
Active,DIRECTORY2,adirectory2,Pass123,adirectory2@blueforestintl.com
Active,DIRECTORY3,adirectory3,Pass123,adirectory3@blueforestintl.com
Active,DIRECTORY4,adirectory4,Pass123,adirectory4@blueforestintl.com
https://blueforest.intl.com/helpdesk/tickets/56712
+++++++++++++End+++++++++++++
Thank you