Data from Outlook mail body to Excel

Vxcel

New Member
Joined
Jan 6, 2018
Messages
2
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:
NameClassSectionAddressSubject 1Subject 2Subject 3Subject 4
ABC4D NRWTN1,HALL ROAD,WHITE LODGE,NORWICH50607080
DEF10GCROYDON SOUTH NORWOOD HILL80708575

<tbody>
</tbody>

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

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Vxcel

New Member
Joined
Jan 6, 2018
Messages
2
I would like to see the Output of the code to be as :

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

Watch MrExcel Video

Forum statistics

Threads
1,123,104
Messages
5,599,750
Members
414,333
Latest member
willfrederick

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top