sailingbikeruk
New Member
- Joined
- Aug 6, 2010
- Messages
- 7
Ive been reading articles and posts on here about the possibility of moving data from tables in the body of emails in Outlook to an excel workbook using VBA, there are so many and none have a direct relationship to what I am trying to achieve so I thought I would post and see if I am just missing something or if someone could help me.
I get alerts from systems when an administrative login fails - this happens more frequently than you'd imagine especially as we force long and complicated passwords on the environment, it sends me an email with tabulated data that looks like the example below (I've cleared some fields for security reasons):
I would like to be able to extract the data from the right hand column into seperate columns in an excel workbook. I need to do this now on a large volume of emails and then subsequently as they are received or added to the folder, so that they don't build up to this level again. I have access to outlook 2016 and excel 2016 for Office 365 on windows and MACOS. I don't mind if it only works on Windows.
Is it possible?
[TABLE="width: 70%, align: center"]
<tbody>[TR]
[TD]
Event Details
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Event Code
[/TD]
[TD] 16
[/TD]
[/TR]
[TR]
[TD]User Name
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Failure Code
[/TD]
[TD] 0x18
[/TD]
[/TR]
[TR]
[TD]Logon Service
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Logon Time
[/TD]
[TD] 02-Sep-2018 10:14:08 BST
[/TD]
[/TR]
[TR]
[TD]Failure Reason
[/TD]
[TD] Bad password
[/TD]
[/TR]
[TR]
[TD]SID
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Remarks
[/TD]
[TD] Kerberos pre-authentication failed.
[/TD]
[/TR]
[TR]
[TD]Event Number
[/TD]
[TD] 4771
[/TD]
[/TR]
[TR]
[TD]Domain Controller
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Event Type
[/TD]
[TD] Failure
[/TD]
[/TR]
[TR]
[TD]Client IP Address
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Domain
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Client Host Name
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Record number
[/TD]
[TD] 1537588319
[/TD]
[/TR]
</tbody>[/TABLE]
I get alerts from systems when an administrative login fails - this happens more frequently than you'd imagine especially as we force long and complicated passwords on the environment, it sends me an email with tabulated data that looks like the example below (I've cleared some fields for security reasons):
I would like to be able to extract the data from the right hand column into seperate columns in an excel workbook. I need to do this now on a large volume of emails and then subsequently as they are received or added to the folder, so that they don't build up to this level again. I have access to outlook 2016 and excel 2016 for Office 365 on windows and MACOS. I don't mind if it only works on Windows.
Is it possible?
[TABLE="width: 70%, align: center"]
<tbody>[TR]
[TD]
Event Details
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Event Code
[/TD]
[TD] 16
[/TD]
[/TR]
[TR]
[TD]User Name
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Failure Code
[/TD]
[TD] 0x18
[/TD]
[/TR]
[TR]
[TD]Logon Service
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Logon Time
[/TD]
[TD] 02-Sep-2018 10:14:08 BST
[/TD]
[/TR]
[TR]
[TD]Failure Reason
[/TD]
[TD] Bad password
[/TD]
[/TR]
[TR]
[TD]SID
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Remarks
[/TD]
[TD] Kerberos pre-authentication failed.
[/TD]
[/TR]
[TR]
[TD]Event Number
[/TD]
[TD] 4771
[/TD]
[/TR]
[TR]
[TD]Domain Controller
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Event Type
[/TD]
[TD] Failure
[/TD]
[/TR]
[TR]
[TD]Client IP Address
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Domain
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Client Host Name
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Record number
[/TD]
[TD] 1537588319
[/TD]
[/TR]
</tbody>[/TABLE]
Last edited: