Struggling - I need to copy specific data from outlook email into excel (html)

Struggling - I need to copy specific data from outlook email into excel
(html)

First I want to apologize as I know there have been some posts on here
about getting data out of outlook and into excel; however, I have tried
for days to alter the samples I found but have not had any luck.
My goal, I think is fairly simple. I am a network engineer who receives
automated emails from our WAN carrier and need to take specific data out
of those emails and put that data into excel. The emails from the carrier
come in html format which I suspect might be one reason I am having so
much trouble. At the bottom of this post is a of an email and I need the
vbscript to read and capture the follow data listed below and then put the
data into seperate fields in excel as follows:
Any help will be greatly appreciated!
Company name: MR COMPANY Request number: 1323656 Event ID: 12345678
Maintenance location: HOLLYWOOD, STATE, UNITED STATES Maintenance window
local: Sep 8 2013 00:01 EDT - Sep 8 2013 06:00 EDT Maintenance window GMT:
Sep 8 2013 04:01 GMT - Sep 8 2013 10:00 GMT
Outage duration: 10 Minutes
Duration: 2 X 10 Minutes
Circuit ID BCBKDDRFL0003
COPY OF EMAIL
Sent: Thursday, August 22, 2013 6:54 PM Subject: Verizon Scheduled
Maintenance Notification - R-123456 / E-12345678 Location: HOLLYWOOD,
CALIFORNIA, UNITED STATES



ENGLISH



Verizon Maintenance Notification
Dear Verizon Customer,
We would like to inform you that maintenance work needs to be carried out
on the Verizon network. Company name: MR COMPANY Request number: 1323656
Event ID: 12345678 Maintenance location: HOLLYWOOD, STATE, UNITED STATES
Maintenance window local: Sep 8 2013 00:01 EDT - Sep 8 2013 06:00 EDT
Maintenance window GMT: Sep 8 2013 04:01 GMT - Sep 8 2013 10:00 GMT
Outage duration: 10 Minutes



Outage Duration greater than 50 milliseconds – Customer Affecting
Outage Duration 50 milliseconds or less – Switch Hits – Non Customer
Affecting



Description of Maintenance:
We will be performing scheduled software maintenance on the network to
provide improved network reliability.
Duration: 2 X 10 Minutes
Company Name Circuit ID A Location Billing ID Expected Outage Window



MR COMPANY BCBKDDRFL0003 HOLLYWOOD, CA 456789 7:00 GMT - 9:00 GMT 7:00 GMT
- 9:00 GMT



We appreciate your cooperation and understanding.
If you have questions regarding this maintenance event, please contact the
Verizon Global Event Notification Center,
United States and Canada Standard Time
EST Eastern Standard Time (GMT -5 hours) CST Central Standard Time (GMT -6
hours) MST Mountain Standard Time (GMT -7 hours) PST Pacific Standard Time
(GMT -8 hours)
EDT Eastern Daylight Time (GMT -4 hours) CDT Central Daylight Time (GMT -5
hours) MDT Mountain Daylight Time (GMT -6 hours) PDT Pacific Daylight Time
(GMT -7 hours)