如何在邮件中加入html代码,如何在电子邮件正文中嵌入HTML文件

如何使用powershell在电子邮件正文中嵌入HTML文件？这就是我到目前为止所做的：

##Connect to the data source using the connection details and T-SQL command we provided above, and open the connection

$connection = New-Object System.Data.OleDb.OleDbConnection $connectionDetails

$command = New-Object System.Data.OleDb.OleDbCommand $sqlCommand,$connection

$connection.Open()

##Get the results of our command into a DataSet object, and close the connection

$dataAdapter = New-Object System.Data.OleDb.OleDbDataAdapter $command

$dataSet = New-Object System.Data.DataSet

$dataAdapter.Fill($dataSet)

$connection.Close()

$body = $TableHeader

$dataSet.Tables | Select-Object -Expand Rows |

Select-Object * -ExcludeProperty Comment, RowError, RowState, Table, ItemArray, HasErrors |

ConvertTo-HTML -head $a –body $body |

Out-File $OutputFile

$ReportLink = "file://serverr/c$/Output/Report.Html"

Write-Output " Reporting"

$MailUsername = "you"

$MailPassword = "your pasword"

$cred = New-Object System.Management.Automation.PSCredential -ArgumentList @($MailUsername,(ConvertTo-SecureString -String $MailPassword -AsPlainText -Force))

Send-MailMessage -To "abc@ymail.com" -From "xyz@ymail.com" -SmtpServer Ymail -Credential $cred -Subject " Report:" -Body $ReportLink -BodyAsHtml

我仍然是PowerShell的新手。提前谢谢