Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

SQL Server – Send email using Powershell

This article explains how to send an email through Powershell. 

 Very useful if you have a requirement to automate your scripts and send notifications .

 The example is calling the SmtpClient Class , which is part of the .Net Framework.

You can call a Function –  which makes your scripting   more modular.


$emailFrom = ""
$emailTo = ""
$subject = " Powershell Function calling an SMTP server"
$body = " : Send an email through SMTP in Powershell"
$smtpServer = "aservername"

#create a function
Function sendEmail([string]$emailFrom, [string]$emailTo, [string]$subject,[string]$body,[string]$smtpServer)
$smtp = new-object Net.Mail.SmtpClient($smtpServer)

#call the function 
sendEmail $emailFrom $emailTo $subject $body $smtpServer


See Also

Powershell - run script on all sql servers


Author: Jack Vamvas (


Leave a comment on the original post [, opens in a new window]

Loading comments...