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

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

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,127,779
Messages
5,626,831
Members
416,203
Latest member
Rebmit1

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