This script uses the Exchange snap-ins to send email.
Open Powershell ISE. Copy the script and add the correct email addresses.
This script uses the Exchange snap-ins to send email.
Open Powershell ISE. Copy the script and add the correct email addresses.
Clear
Add-PSSnapin Microsoft.Exchange.Management.Powershell.Admin -erroraction silentlyContinue
function sendmail_withAttachment {
Param (
#[Parameter(Mandatory=$true)]
[string] $smtpServer = "",
[string] $From_mail = "",
[string] $to_mail = "",,
[string] $cc_mail = "",,
[string] $Subject = "Notification from email server"
)
Write-Host “`n Starting script, Sending Email to Recipients.....” -ForegroundColor Green
$text= ''
$body = ''
$text = "Attached is the email server mailbox report"
$body = "<font color="red"><b>$text</b></font><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>"
$body += "--------------------------------------------------------------------------------------------------------"
$body += "<footer><p><font size="2">Contact DBA Team if you have any question.<Br>--------------------------------------------------------------------------------------------------------</footer></font><br>"
$filename = "sqllog.txt"
$file= "C:\Folder\" + $filename
$att = new-object Net.Mail.Attachment($file)
$msg = new-object Net.Mail.MailMessage
$smtp = new-object Net.Mail.SmtpClient($smtpServer)
#$smtp.Send($smtpFrom,$smtpTo,$messagesubject,$messagebody)
$msg.IsBodyHTML = $true
$msg.Body = $body
$msg.From = $From_mail;
$msg.To.Add($to_mail)
$msg.CC.Add($cc_mail)
$msg.Subject = $Subject;
$logs = Get-Content $file | Out-String
$msg.Attachments.Add($att)
$smtp.Send($msg)
#--Priority high
$att.Dispose()
}
sendmail_withAttachment