# Send Get-EXOMailbox in email

**URL:** <https://forums.powershell.org/t/send-get-exomailbox-in-email/17581>\
**Category:** PowerShell Help\
**Created:** [September 21, 2021, 2:48pm UTC](https://forums.powershell.org/t/send-get-exomailbox-in-email/17581 "2021-09-21T14:48:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Isaque](https://avatars.discourse-cdn.com/v4/letter/i/59ef9b/32.png) [@Isaque](https://forums.powershell.org/u/Isaque)\
**Post date:** [September 21, 2021, 2:48pm UTC](https://forums.powershell.org/t/send-get-exomailbox-in-email/17581/1 "2021-09-21T14:48:00Z")

</div>

Esteemed,  
I have the following Script that brings me mailboxes above a certain size, I would like to send this result in the email, I have the email script but I am not able to deploy.

Result:

```auto
Connect-ExchangeOnline -UserPrincipalName teste@ *****
Get-EXOMailbox -ResultSize Unlimited | Get-EXOMailboxStatistics | Where-Object {[int64]($PSItem.TotalItemSize.Value -replace '.+\(|bytes\)') -gt "40GB"} | Sort-Object TotalItemSize -Descending | Select-Object DisplayName, ItemCount, TotalItemSize

```

email script:

```auto
$EmailFrom = “teste@ ****** ”
$EmailTo = “teste@ ******* ”
$Subject = “teste ***** ”
$Body = “teste ***** ”
$SMTPServer = “smtp.office365.com”
$SMTPClient = New-Object Net.Mail.SmtpClient($SmtpServer, 587)
$SMTPClient.EnableSsl = $true
$SMTPClient.Credentials = New-Object System.Net.NetworkCredential(“teste@ *******”, “******* ”);
$SMTPClient.Send($EmailFrom, $EmailTo, $Subject, $Body)

```

---

<div class="post-metadata">

**Author:** ![kvprasoon](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.powershell.org/kvprasoon/32/4449_2.png) [@kvprasoon](https://forums.powershell.org/u/kvprasoon)\
**Post date:** [September 21, 2021, 3:17pm UTC](https://forums.powershell.org/t/send-get-exomailbox-in-email/17581/2 "2021-09-21T15:17:48Z")

</div>

Great. Have a look at [Send-MailMessage (Microsoft.PowerShell.Utility) - PowerShell | Microsoft Docs](https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/send-mailmessage?view=powershell-5.1). It should solve your problem. Its the built-in cmdlet for this.

---

<div class="post-metadata">

**Author:** ![dotnVo](https://avatars.discourse-cdn.com/v4/letter/d/4af34b/32.png) [@dotnVo](https://forums.powershell.org/u/dotnVo)\
**Post date:** [May 16, 2024, 8:21pm UTC](https://forums.powershell.org/t/send-get-exomailbox-in-email/17581/3 "2024-05-16T20:21:22Z")

</div>