Powershell has great functionalities. One of those is the sendmail function. We used it like a timer job for reminding people to do something special. We built a small script which checks certain list items in SharePoint and fetches the title, the create date and the author. If the item is older than 30 days, the author gets a reminder to do a task on the item.
The powershell is stored as scheduled task in windows. But i’d like to share the sendmail function with you.
[sourcecode language=”csharp”]
$to = “you@mailadress.com”
$subject = ‘Subject Text’
$body = ‘Body Text’
#SMTP server name (which is configured in SharePoint)
$smtpServer = “SMTPServer”
#Creating a Mail object
$msg = new-object Net.Mail.MailMessage
#Creating SMTP server object
$smtp = new-object Net.Mail.SmtpClient($smtpServer)
#Email structure
$msg.From = “yoursender@mailadress.com”
$msg.To.Add($to.Email)
$msg.subject = $subject
$msg.body = $body
$msg.isBodyHTML = $true
#Sending email
$smtp.Send($msg)
[/sourcecode]
That’s it. Now you can put some values from the list into the body or subject or even the receiver address (to). Enjoy it.
With this code you can even extract the configured mailserver from sharepoint, so no need to configure it twice:
$SPGlobalAdmin = New-Object Microsoft.SharePoint.Administration.SPGlobalAdmin
$smtpServer = $SPGlobalAdmin.OutboundSmtpServer
thanks Georg for sharing this. Great!
On error in the above code: use $to instead of $to.Email