Extracting Table Data from Outlook to Excel

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]
 
Last edited:

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Forum statistics

Threads
1,223,228
Messages
6,170,876
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top