Powershell HTML email formatting

Question

The below script puts database backup details into a nicely formatted table with borders and saves as a .htm. It then emails the report, but when the report is emailed the 'table' has no borders and no gap between the 'LastBackupDate' column and the 'LastLogBackupDate' column - it basically looks the same as the results would on the powershell console. Can anyone tell me how to format the email so all the html is used from the file? P.s. I can't use send-mailmessage due to issues with gmail ssl. Thanks.

#HTML 
$a = "<style>"
$a = $a + "TABLE{border-width: 1px;border-style: solid;border-color: black;border-collapse: collapse;}"
$a = $a + "TH{border-width: 1px;padding: 10px;border-style: solid;border-color: black;}"
$a = $a + "TD{border-width: 1px;padding: 10px;border-style: solid;border-color: black;}"
$a = $a + "</style>"

#Set Date
$date = ( get-date ).ToString('yyyyMMdd')

#Locate DB
[System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SMO') | out-null
$s = New-Object ('Microsoft.SqlServer.Management.Smo.Server') "LOCALHOST\SQLX64"

#Retrieves the last backup dates - for full and log backups
$dbs=$s.Databases
$backups = $dbs | SELECT Name,LastBackupDate, LastLogBackupDate | Sort-Object LastBackupDate | ConvertTo-HTML -head $a -body "<H2>DB01 Database Backup Details $date </H2>" | Out-File $("D:\SQL_Backup_Log_Script\Logs\Backup_Log_Temp.htm")

#Email Report
$EmailFrom = "[email protected]"
$emailto = "[email protected]"
$Subject = "Database Backup Log $date" 
$Body = Get-Content D:\SQL_Backup_Log_Script\Logs\Backup_Log_Temp.htm
$SMTPServer = "smtp.gmail.com" 
$SMTPClient = New-Object Net.Mail.SmtpClient($SmtpServer, 587) 
$SMTPClient.EnableSsl = $true 
$SMTPClient.Credentials = New-Object System.Net.NetworkCredential("[email protected]", "password here"); 
$message = New-Object Net.Mail.MailMessage($EmailFrom, $EmailTo, $Subject, $Body)
$message.IsBodyHtml = $true;
$SMTPClient.Send($message)

#Rename file to include today's date
Rename-Item -path D:\SQL_Backup_Log_Script\Logs\Backup_Log_Temp.htm -newname ($date +"_DB01_Backup_Log.htm")

As an aside, consider replacing your "$a = $a + " repetition with 'here strings' in PowerShell. It'll make your life a little easier. technet.microsoft.com/en-us/library/ee692792.aspx — xcud
– xcud, Commented Feb 8, 2012 at 14:53
+1 @xcud. Charlotte, the file looks OK in your browser before you send it out? — Shay Levy
– Shay Levy, Commented Feb 8, 2012 at 15:34
@xcud - thanks, yes that is useful and will make life easier. — Charlotte
– Charlotte, Commented Feb 8, 2012 at 16:17

CB. · Accepted Answer · 2012-02-08 15:05:47Z

1

Try change this line (can't test if is this the problem):

$Body = [System.IO.File]::ReadAllText("D:\SQL_Backup_Log_Script\Logs\Backup_Log_Temp.htm")

the body property in Net.Mail.MailMessage accept [string], get-content return [string[]].

edited Feb 8, 2012 at 15:05

answered Feb 8, 2012 at 14:52

CB.

61.3k9 gold badges170 silver badges165 bronze badges

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

2 Comments

Charlotte Over a year ago

Thanks but the emailed report hasn't changed.

Charlotte Over a year ago

Just realised, the email has been formatting fine the whole time, just GMAIL won't display the formatting. It looks good in Outlook!

Collectives™ on Stack Overflow

Powershell HTML email formatting

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related