• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3396
  • Last Modified:

Send MailMessage Powershell Script CSV as attachment

I have a powershell script that generates a csv file.  I want to have this csv file e-mailed as an attachment.  how can I accomplish this by either integrating the instruction to the existing script, or creating another script to send the csv file.  Below is the script. Thank you.

$Mailboxes = Get-Mailbox -Filter {RecipientTypeDetails -eq "UserMailbox"} -ResultSize Unlimited
$Output = @()
ForEach ($Mailbox in $Mailboxes) {
 # Get the name of the calendar folder
 $Calendar = (($Mailbox.PrimarySmtpAddress.ToString())+ ":\" + (Get-MailboxFolderStatistics -Identity $Mailbox.DistinguishedName -FolderScope Calendar | Select-Object -First 1).Name)
 $Permissions = Get-MailboxFolderPermission -Identity $Calendar
 ForEach ($Permission in $Permissions) {
  $Permission | Add-Member -MemberType NoteProperty -Name "Mailbox" -value $Mailbox.DisplayName
  $Output = $Output + $Permission
 }
}
$Output | Select-Object Mailbox, User, {$_.AccessRights}, IsValid | Export-Csv -Path C:\CalendarPermissions.csv -NoTypeInformation

Open in new window

0
fireguy1125
Asked:
fireguy1125
1 Solution
 
footechCommented:
Just use Send-MailMessage.  You may have to add some parameters (like -credential or -port) depending on your mail server.  Check out the help for info on parameters.  Here's the basic format...
Send-MailMessage -To "someone@company.com" -From "script@company.com" -Subject "here's the file" -Body "file is attached" -Attachments "C:\CalendarPermissions.csv" -SmtpServer "smtp.company.com"

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now