Run a Console Application and Mail Output Report with PowerShell

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue 

#Trigger the executable file
Start-Process "D:\Scripts\StorageReport\GetStorageReport.exe"

# Wait until the report is generated
while(-not (Test-Path "D:\Scripts\StorageReport\StorageReport.csv"))
  {
    Start-Sleep 30  #sleep for 30 seconds
  }
  
$ReportDate=get-date -Format "MMM-dd-yyyy"

#Rename the Report 
Rename-Item -Path "D:\Scripts\StorageReport\StorageReport.csv" -NewName "D:\Scripts\StorageReport\StorageReport_$ReportDate.csv"
 
  #Send the Mail
 $MailMessageParameters = @{
    SmtpServer = "smtp.company.org"
    Subject = "SharePoint Storage Report - $ReportDate"
    Body = "Please find attached Database storage report as on $ReportDate"
    From = "SharePointReports@company.com"
    To = "AdminTeam@company.com"
    Attachments ="D:\Scripts\StorageReport\StorageReport_$ReportDate.csv"
}
 Send-MailMessage @MailMessageParameters
 
 #Remove the Report
 if (Test-Path "D:\Scripts\StorageReport\StorageReport_$ReportDate.csv")
 {
    Remove-Item "D:\Scripts\StorageReport\StorageReport_$ReportDate.csv"
 }