Hi.
I've had a look on line but all the Macros are too complicated. I am looking for the following
Looking for an email with the title
West Availability Report – 0500hrs Tuesday 25th July 2017 ( the date changes daily)
to extract information in it (a table to be exact) and move it to Excel
[TABLE="class: MsoNormalTable, width: 548"]
<tbody>[TR]
[TD="width: 120, bgcolor: transparent"] <o></o>
[/TD]
[TD="width: 99, bgcolor: transparent"][/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 75, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 224, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 120, bgcolor: transparent"] Class 143<o></o>
[/TD]
[TD="width: 99, bgcolor: transparent"][/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 75, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 224, bgcolor: transparent"] <o></o>
[/TD]
[/TR]
[TR]
[TD="width: 120, bgcolor: transparent"] Class 150/0<o></o>
[/TD]
[TD="width: 99, bgcolor: transparent"][/TD]
[TD="width: 67, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 224, bgcolor: transparent"] <o></o>
[/TD]
[/TR]
[TR]
[TD="width: 120, bgcolor: transparent"] Class 150/1<o></o>
[/TD]
[TD="width: 99, bgcolor: transparent"][/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 75, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 224, bgcolor: transparent"] <o></o>
[/TD]
[/TR]
[TR]
[TD="width: 120, bgcolor: transparent"] Class 150/2<o></o>
[/TD]
[TD="width: 99, bgcolor: transparent"][/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 75, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 224, bgcolor: transparent"] <o></o>
[/TD]
[/TR]
[TR]
[TD="width: 120, bgcolor: transparent"] Class 150/9<o></o>
[/TD]
[TD="width: 99, bgcolor: transparent"][/TD]
[TD="width: 67, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 224, bgcolor: transparent"] <o></o>
[/TD]
[/TR]
[TR]
[TD="width: 120, bgcolor: transparent"] Class 153<o></o>
[/TD]
[TD="width: 99, bgcolor: transparent"][/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 75, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 224, bgcolor: transparent"] <o></o>
[/TD]
[/TR]
[TR]
[TD="width: 120, bgcolor: transparent"] Class 158 2-Car<o></o>
[/TD]
[TD="width: 99, bgcolor: transparent"] [/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 75, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 224, bgcolor: transparent"] <o></o>
[/TD]
[/TR]
[TR]
[TD="width: 120, bgcolor: transparent"] Class 158 3-Car<o></o>
[/TD]
[TD="width: 99, bgcolor: transparent"][/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 75, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 224, bgcolor: transparent"] <o></o>
[/TD]
[/TR]
[TR]
[TD="width: 120, bgcolor: transparent"] Class 166<o></o>
[/TD]
[TD="width: 99, bgcolor: transparent"][/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 75, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"] [/TD]
[TD="width: 224, bgcolor: transparent"] <o></o>
[/TD]
[/TR]
[TR]
[TD="width: 120, bgcolor: transparent"] Hired-in Resources<o></o>
[/TD]
[TD="width: 99, bgcolor: transparent"][/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 75, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 224, bgcolor: transparent"] <o></o>
[/TD]
[/TR]
[TR]
[TD="width: 120, bgcolor: transparent"] TOTALS<o></o>
[/TD]
[TD="width: 99, bgcolor: transparent"][/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 75, bgcolor: transparent"][/TD]
[TD="width: 76, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 224, bgcolor: transparent"]
[/TD]
[/TR]
</tbody>[/TABLE]
Any help is appreciated.
I've had a look on line but all the Macros are too complicated. I am looking for the following
Looking for an email with the title
West Availability Report – 0500hrs Tuesday 25th July 2017 ( the date changes daily)
to extract information in it (a table to be exact) and move it to Excel
[TABLE="class: MsoNormalTable, width: 548"]
<tbody>[TR]
[TD="width: 120, bgcolor: transparent"] <o></o>
[/TD]
[TD="width: 99, bgcolor: transparent"]
Units in Class<o></o>
[TD="width: 67, bgcolor: transparent"]
Stopped<o></o>
[TD="width: 75, bgcolor: transparent"]
Available<o></o>
[TD="width: 76, bgcolor: transparent"]
Diagrams<o></o>
[TD="width: 71, bgcolor: transparent"]
Balance<o></o>
[TD="width: 224, bgcolor: transparent"]
Stopped Units<o></o>
[/TR]
[TR]
[TD="width: 120, bgcolor: transparent"] Class 143<o></o>
[/TD]
[TD="width: 99, bgcolor: transparent"]
<o></o>
[TD="width: 67, bgcolor: transparent"]
<o></o>
[TD="width: 75, bgcolor: transparent"]
<o></o>
[TD="width: 76, bgcolor: transparent"]
<o></o>
[TD="width: 71, bgcolor: transparent"]
[TD="width: 224, bgcolor: transparent"] <o></o>
[/TD]
[/TR]
[TR]
[TD="width: 120, bgcolor: transparent"] Class 150/0<o></o>
[/TD]
[TD="width: 99, bgcolor: transparent"]
<o></o>
[TD="width: 67, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"]
<o></o>
[TD="width: 76, bgcolor: transparent"]
<o></o>
[TD="width: 71, bgcolor: transparent"]
<o></o>
[TD="width: 224, bgcolor: transparent"] <o></o>
[/TD]
[/TR]
[TR]
[TD="width: 120, bgcolor: transparent"] Class 150/1<o></o>
[/TD]
[TD="width: 99, bgcolor: transparent"]
[TD="width: 67, bgcolor: transparent"]
<o></o>
[TD="width: 75, bgcolor: transparent"]
[TD="width: 76, bgcolor: transparent"]
[TD="width: 71, bgcolor: transparent"]
<o></o>
[TD="width: 224, bgcolor: transparent"] <o></o>
[/TD]
[/TR]
[TR]
[TD="width: 120, bgcolor: transparent"] Class 150/2<o></o>
[/TD]
[TD="width: 99, bgcolor: transparent"]
[TD="width: 67, bgcolor: transparent"]
<o></o>
[TD="width: 75, bgcolor: transparent"]
[TD="width: 76, bgcolor: transparent"]
[TD="width: 71, bgcolor: transparent"]
<o></o>
[TD="width: 224, bgcolor: transparent"] <o></o>
[/TD]
[/TR]
[TR]
[TD="width: 120, bgcolor: transparent"] Class 150/9<o></o>
[/TD]
[TD="width: 99, bgcolor: transparent"]
<o></o>
[TD="width: 67, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"]
<o></o>
[TD="width: 76, bgcolor: transparent"]
<o></o>
[TD="width: 71, bgcolor: transparent"]
<o></o>
[TD="width: 224, bgcolor: transparent"] <o></o>
[/TD]
[/TR]
[TR]
[TD="width: 120, bgcolor: transparent"] Class 153<o></o>
[/TD]
[TD="width: 99, bgcolor: transparent"]
[TD="width: 67, bgcolor: transparent"]
<o></o>
[TD="width: 75, bgcolor: transparent"]
[TD="width: 76, bgcolor: transparent"]
[TD="width: 71, bgcolor: transparent"]
<o></o>
[TD="width: 224, bgcolor: transparent"] <o></o>
[/TD]
[/TR]
[TR]
[TD="width: 120, bgcolor: transparent"] Class 158 2-Car<o></o>
[/TD]
[TD="width: 99, bgcolor: transparent"] [/TD]
[TD="width: 67, bgcolor: transparent"]
<o></o>
[TD="width: 75, bgcolor: transparent"]
<o></o>
[TD="width: 76, bgcolor: transparent"]
<o></o>
[TD="width: 71, bgcolor: transparent"]
<o></o>
[TD="width: 224, bgcolor: transparent"] <o></o>
[/TD]
[/TR]
[TR]
[TD="width: 120, bgcolor: transparent"] Class 158 3-Car<o></o>
[/TD]
[TD="width: 99, bgcolor: transparent"]
[TD="width: 67, bgcolor: transparent"]
<o></o>
[TD="width: 75, bgcolor: transparent"]
<o></o>
[TD="width: 76, bgcolor: transparent"]
[TD="width: 71, bgcolor: transparent"]
<o></o>
[TD="width: 224, bgcolor: transparent"] <o></o>
[/TD]
[/TR]
[TR]
[TD="width: 120, bgcolor: transparent"] Class 166<o></o>
[/TD]
[TD="width: 99, bgcolor: transparent"]
<o></o>
[TD="width: 67, bgcolor: transparent"]
<o></o>
[TD="width: 75, bgcolor: transparent"]
<o></o>
[TD="width: 76, bgcolor: transparent"]
<o></o>
[TD="width: 71, bgcolor: transparent"] [/TD]
[TD="width: 224, bgcolor: transparent"] <o></o>
[/TD]
[/TR]
[TR]
[TD="width: 120, bgcolor: transparent"] Hired-in Resources<o></o>
[/TD]
[TD="width: 99, bgcolor: transparent"]
<o></o>
[TD="width: 67, bgcolor: transparent"]
<o></o>
[TD="width: 75, bgcolor: transparent"]
<o></o>
[TD="width: 76, bgcolor: transparent"]
<o></o>
[TD="width: 71, bgcolor: transparent"]
<o></o>
[TD="width: 224, bgcolor: transparent"] <o></o>
[/TD]
[/TR]
[TR]
[TD="width: 120, bgcolor: transparent"] TOTALS<o></o>
[/TD]
[TD="width: 99, bgcolor: transparent"]
[TD="width: 67, bgcolor: transparent"]
[TD="width: 75, bgcolor: transparent"]
[TD="width: 76, bgcolor: transparent"]
[TD="width: 71, bgcolor: transparent"]
<o></o>
[TD="width: 224, bgcolor: transparent"]
[/TD]
[/TR]
</tbody>[/TABLE]
Any help is appreciated.