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 :
<tbody>
</tbody>
Any help/leads on how this can be done ?
Thanks !
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:
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 !