MSExchangeGuru.com

This article will show you how to send an Email, with attachment, within your domain by using the Send-MailMessage command and sending it directly through a HUB server.

First, let’s create the PS1 script:

Copy and paste the following code into notepad and save as (Save as type: all files) with the name SendEmail.ps1. You will need to change the text in bold to the appropriate HUB server IP address, the SMTP of who you are sending to, the SMTP of who you want it to be from, and then of course the subject and body to be displayed in the Email.

#CODE STARTS HERE
#Written by Doug Spear
#MSExchangeGuru.com

Add-PSSnapin Microsoft.Exchange.Management.Powershell.Admin -erroraction silentlyContinue
$file = “c:\file.csv”
Send-MailMessage -SmtpServer HUB.SERVER.IP.HERE -To COWORKER.EMAIL@DOMAIN.COM -From YOUR.EMAIL@DOMAIN.COM -Subject “SUBJECT HERE” -Body “BODY HERE” -attachment $file

#CODE ENDS HERE

Now I know what you’re saying, that’s cool but not that cool…

Well, how about we make it cool. Rather than just having an existing file to send as an attachment, think of the possibilities if you have data exported to the file prior to the Send-MailMessage command (change USERHERE in bold below to a valid mailbox):

Get-MailboxStatistics USERHERE | select-object DisplayName, ItemCount, TotalItemSize, TotalDeletedItemSize, LastLogonTime, LastLogoffTime | export-csv “c:\file.csv” -NoTypeInformation

Now you have a script that looks like this:

#CODE STARTS HERE
#Written by Doug Spear
#MSExchangeGuru.com

Add-PSSnapin Microsoft.Exchange.Management.Powershell.Admin -erroraction silentlyContinue
Get-MailboxStatistics USERHERE | select-object DisplayName, ItemCount, TotalItemSize, TotalDeletedItemSize, LastLogonTime, LastLogoffTime | export-csv “c:\file.csv” -NoTypeInformation
$file = “c:\file.csv”
Send-MailMessage -SmtpServer HUB.SERVER.IP.HERE -To COWORKER.EMAIL@DOMAIN.COM -From YOUR.EMAIL@DOMAIN.COM -Subject “SUBJECT HERE” -Body “BODY HERE” -attachment $file

#CODE ENDS HERE

Now you have a simpler way of sending yourself, or your boss, mailbox statistics. This is just the beginning of the endless possibilities with this simple script!

Note: This scirpt is mainly to be used in Exchange PowerShell. The main “meat and potatoes” script using the Send-MailMessage command will work for Windows PowerShell without piping the Exchange data and is fun to use for testing.

Posted July 10th, 2013 under Exchange 2010, Powershell. Tags: send attachment in powershell, send email, send email in powershell, send email with attachment in powershell
RSS 2.0 feed. Leave a response, or trackback.