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:​

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Class[/TD]
[TD]Section[/TD]
[TD]Address[/TD]
[TD]Subject 1[/TD]
[TD]Subject 2[/TD]
[TD]Subject 3[/TD]
[TD]Subject 4[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]4[/TD]
[TD]D[/TD]
[TD] NRWTN1,HALL ROAD,WHITE LODGE,NORWICH[/TD]
[TD]50[/TD]
[TD]60[/TD]
[TD]70[/TD]
[TD]80[/TD]
[/TR]
[TR]
[TD]DEF[/TD]
[TD]10[/TD]
[TD]G[/TD]
[TD]CROYDON SOUTH NORWOOD HILL[/TD]
[TD]80[/TD]
[TD]70[/TD]
[TD]85[/TD]
[TD]75[/TD]
[/TR]
</tbody>[/TABLE]
​

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