Extract Table from Outlook Message body to Excel using VBA

JeysJeys

New Member
Joined
Sep 22, 2015
Messages
7
Hi, I wanna extract email body table from Outlook to excel and I am using outlook 2007 and all emails are available in Sent folder moreover my subject is same in all emails but body text could be different.
Please help me in this regard.Thankx in Advance.
BELOW IS THE EMAIL BODY.
Dear Sir,

We warmly welcome you to the MY family. We are honored and privileged to have you with us and hope it serves your business objectives.

We are delighted to inform you that the campaign for your Client XXXXX with Brand XXXX, has commenced on air, and it will be our sincere endeavor to make your objectives come alive on HAPPY.

Following are the details of your campaign:

Quote ID
Campaign Start date
Campaign End date
Name of Sales Person
Advertiser Name
Agency Name
123456
01-SEP-2015
05-SEP-2015
AMJAD
ASDASDAS

<tbody>
</tbody>

The growth we’ve experienced over the years is because of customers like you who faithfully support our business. We appreciate your trust, and we’ll do our best to continue to give you unmatched service quality.
We strive to achieve highest standards of service i.e. your standard of expectations, and look forward to your feedback. Please click on the link and send us your feedback about us: -
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Forum statistics

Threads
1,216,609
Messages
6,131,723
Members
449,667
Latest member
PSAv

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
Back
Top