1

Hi all,

Need some help with the below powerhshell query.

The e-mail sends fine, but it outputs the HTML as plain text.

I’ve tried adding $body += Converto-HTML but it doesn’t change anything. I can’t find anywhere where I can parse -BodyIsHTML also

# mail message properties
$fromemail = "abc@abc.com"
$users = "abc@abc.com"
$Subject = "Disk Space Alert"

# smtp auth details
$SMTPClient = "smtp.office365.com" 
$SMTPClient = New-Object Net.Mail.SmtpClient($SmtpServer, 587)
$SMTPClient.EnableSsl = $true
$SMTPClient.Credentials = New-Object System.Net.NetworkCredential("abc@abc.com", "smtp password"); 
$SMTPClient.Send($fromemail, $users, $Subject, $body); 

# list properties
$list = "C:\Users\Desktop\diskspacereport\list.txt" 
$computers = get-content $list 
[decimal]$thresholdspace = 20

#assemble together all of the free disk space data from the list of servers and only include it if the percentage free is below the threshold we set above.
$tableFragment= Get-WMIObject  -ComputerName $computers Win32_LogicalDisk `
| select __SERVER, DriveType, VolumeName, Name, @{n='Size (Gb)' ;e={"{0:n2}" -f ($_.size/1gb)}},@{n='FreeSpace (Gb)';e={"{0:n2}" -f ($_.freespace/1gb)}}, @{n='PercentFree';e={"{0:n2}" -f ($_.freespace/$_.size*100)}} `
| Where-Object {$_.DriveType -eq 3 -and [decimal]$_.PercentFree -lt [decimal]$thresholdspace}

# assemble the HTML for our body of the email report.
$HTMLmessage = @"
<font color=""black"" face=""Arial, Verdana"" size=""3"">
<u><b>Disk Space Storage Report</b></u>
<br>The server volume(s) listed below have less than $thresholdspace % free space. Volumes above this threshold will not be listed in this report.
<br>
<style type=""text/css"">body{font: .8em ""Lucida Grande"", Tahoma, Arial, Helvetica, sans-serif;}
ol{margin:0;padding: 0 1.5em;}
table{color:#376;background:#CCC;border-collapse:collapse;width:647px;border:5px solid #525;}
thead{}
thead th{padding:1em 1em .5em;border-bottom:1px dotted #FFF;font-size:120%;text-align:left;}
thead tr{}
td{padding:.5em 1em;}
tfoot{}
tfoot td{padding-bottom:1.5em;}
tfoot tr{}
#middle{background-color:#525;}
</style>
<body BGCOLOR=""white"">
$tableFragment
</body>
"@
4 Spice ups
2

Why not just Send-MailMessage with the -BodyAsHTML parameter?

3 Spice ups
3

This should cover it . Alternatively use Send-MailMessage cmdlet instead of .NET method, that would be a more PowerShelly way

2 Spice ups
4

Hi

Thanks for the reply.

I originally did try this but was encountering authentication errors. For now I have added the send-mailmessage cmdlet with that that -bodyashtml tag and it works in part so thankyou for that - I just need to make the script unattended now (so it inputs the password)

5

Quick guide here on how to export credentials and import them from a file:

https://www.jaapbrasser.com/quickly-and-securely-storing-your-credentials-powershell/

Might not be the most secure method but it’s better than hard coding a password into your script in plain text, plus you can control access with NTFS permissions etc