RobertlBooth
IS-IT--Management
Hello,
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)
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)
