Extracting Table Data from Outlook to Excel

[sailingbikeruk]

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?

Event Details
Event Code	16
User Name
Failure Code	0x18
Logon Service
Logon Time	02-Sep-2018 10:14:08 BST
Failure Reason	Bad password
SID
Remarks	Kerberos pre-authentication failed.
Event Number	4771
Domain Controller
Event Type	Failure
Client IP Address
Domain
Client Host Name
Record number	1537588319

<tbody>
</tbody>

 

[John_w]

Try adapting the code at https://www.mrexcel.com/forum/excel...ted-folder-excel-post4727139.html#post4727139