Using Powershell to Format Output of Array via a table for HTML EMail

Question

I'm attempting to build a table from an array and then place it into an email. I'm able to get the table to show the first item from the array, but can't get the rest of the items to be listed. I feel like I'm close, any ideas on what I may be missing.

$global:Report = "C:\TEMP\Scripts\PowerShell\ReadExcelFiles\File.csv"
$UViolation = import-csv $global:Report -Delimiter '    ' | Where-Object {$_.Rules -eq "TESTTEXTINFILE"}
$UserViolationDetails = New-Object System.Collections.ArrayList

foreach ($item in $UViolation){
    if ($item.Destination -notcontains "HP ") {
    $UserViolationDetails += ,@($item.'User Name', $item.'Occurred (Endpoint)',$item.'IP Address',$item.'Computer Name',$item.Destination)
    }
}
$UserID = "USERID01"
$events = $UserViolationDetails -match $UserID
$count = 0
foreach ($line in $events){
    $count++
    $table = @( @{'User ID'=$line[0]; 'DateTime'=$line[1]})
}
$count
$table.ForEach({[PSCustomObject]$_}) | Format-Table -AutoSize

$ol = New-Object -comObject Outlook.Application
$mail = $ol.CreateItem(0) 
$mail.To = "$global:UserReportsToEmail"
$mail.cc = "[email protected]"
$mail.Subject = "mySubject" 
$mail.HTMLBody = 
"<font color ='blue'><b>TESTING STUFFFF!</b></font><br>
Text on a new line $UserID<br>$table"

$inspector = $mail.GetInspector
$inspector.Display()

Guvante · Accepted Answer · 2016-10-26 18:09:27Z

2

$table = @( @{'User ID'=$line[0]; 'DateTime'=$line[1]})

You are setting the table every line here to a single element array.

$table = @()
foreach ($line in $events){
    $count++
    $table += @{'User ID'=$line[0]; 'DateTime'=$line[1]}
}

This creates the array ahead of time and appends items as you add them.

answered Oct 26, 2016 at 18:09

Guvante

19.3k1 gold badge38 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

MrMr Over a year ago

One other question, would you happen to know if theres a way to pick the order of the columns? e.g. 'User ID' first and then 'DateTime'? It seems to pick it's own format.

MrMr Over a year ago

Also, I can't seem to get this to show up in the html body of the email as it does in the console. I shows as an "...object..."

Guvante · Accepted Answer · 2016-10-28 22:35:25Z

0

I was able to add the following to output the table variable ($out) via the html body:

$out = $table.ForEach({[PSCustomObject]$_}) |ConvertTo-Html |Out-String

edited Oct 28, 2016 at 22:35

Guvante

19.3k1 gold badge38 silver badges64 bronze badges

answered Oct 26, 2016 at 18:48

MrMr

4931 gold badge11 silver badges29 bronze badges

Collectives™ on Stack Overflow

Using Powershell to Format Output of Array via a table for HTML EMail

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related