This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi,
I have below Powershell script that sends an email with an Excel CSV file attached.
I would like to know what do I need to change/add on below script so that it will just scan the contents of the CSV file and throw its content to the Outlook email body, so Column, Rows and data will be on the Outlook Body instead so no need for the CSV file to be attached on the email.
And if the Excel CSV file has nothing on it, Outlook will still send email but no column, rows and data in the body (Just like a blank email body).
So it will be easier for the recipient to look on the data instead of clicking the email then clicking the CSV file attached.
Thank you
Powershell command:
Get-ChildItem "C:\PowerShell\Result.csv" | Send-MailMessage -Credential $cred -to "@gmail.com" -from "x@gmail.com" -Subject "Testing" -body "This is a Test" -SmtpServer "mailhost.xxx.xxx.com" -Priority High
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 74%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
See if this works for you:
$htmlfragment = Import-CSV C:\PowerShell\Result.csv | ConvertTo-Html -Fragment
$x = @"
<p>This is just a test</p>
$htmlfragment
"@
Send-MailMessage -To ******@dom.com -From ******@dom.com -Subject "Just a test" -Body $x -BodyAsHtml -SmtpServer ******@dom.com
As always, thanks @Rich Matheisen the above script works. Just additional question, the table from the CSV file that shows on the email body don't have excel grid lines, how to add that please and how can I make the column header bold for --> PC Hostname, PC Owner and Result?
You can add a <styles></styles> section to the message body.
Here's a quick example, using the code I posted earlier:
$htmlfragment = Import-CSV C:\PowerShell\Result.csv | ConvertTo-Html -Fragment
$style = @"
<!-- (A) TABLE BORDERS -->
<style>
table {border-collapse: collapse }
table th { border: 2px solid black }
table td { border: 1px solid black }
</style>
"@
$x = @"
$style
<p>This is just a test</p>
$htmlfragment
"@
Send-MailMessage -To ******@dom.com -From ******@dom.com -Subject "Just a test" -Body $x -BodyAsHtml -SmtpServer ******@dom.com
@Rich Matheisen you're amazing! It's all good now. Thank you