Data from Outlook mail body to Excel

[Vxcel]

Hi Group,
Greetings for the day !
Please find below my query :

I have created a sub-folder by name "Request" on my outlook mailbox where I have run a rule based on certain specific words in the subject line.
Now, all the mails in this particular mailbox have certain text in the mail body followed by a Table of Contents.

The table can have any number of rows but it has 8 column headers . Out of those 8, I want to retrieve only the 4th Column Data which is by name Address and export that specific column data to excel.
I need to run a macro so that it runs through this specified folder and gives me the 4th column data only.

For example the email body looks this :

School Notice

Dear Student,

Please see below details :

Detailed Description:
Check this schedule below

Start date:
10 January 2018

End Date:
NA

Services Impacted:​

Name	Class	Section	Address	Subject 1	Subject 2	Subject 3	Subject 4
ABC	4	D	NRWTN1,HALL ROAD,WHITE LODGE,NORWICH	50	60	70	80
DEF	10	G	CROYDON SOUTH NORWOOD HILL	80	70	85	75

<tbody>
</tbody>

Any help/leads on how this can be done ?
Thanks !

 

[Vxcel]

I would like to see the Output of the code to be as :

Address
NRWTN1,HALL ROAD,WHITE LODGE,NORWICH
CROYDON SOUTH NORWOOD HILL