How can i send mail if the file not exist

marlon3 · 2021-04-16T09:52:39.000Z

Hi Team,

i would like to seek you help.

see my script if its correct , i just want to send mail if my file not exist, im using gmail

Thank

$Mail=import-csv 'C:\VMWare vCenter PID Enumeration\testemail.csv'
$path="C:\VMWare vCenter PID Enumeration"
$input=Test-Path -Path "$path\ListofvCenter.txt"
$userinput=test-path -Path "$path\user.txt"
$passinput=test-path -Path "$path\pass.txt"
$Email=Test-Path -Path "$path\email.csv"

$Files=Get-ChildItem -Path 'C:\VMWare vCenter PID Enumeration' 

foreach($Filename in $Files){
    if($Filename.Name -eq "email.csv"){
        $FileEmail =$true
    } 
    Else{
        $FileEmail= $false
    }

     if($Filename.Name -eq "ListofvCenter.txt"){
      $FilevCenter =$true
           
    } 
    Else
    {
        $FilevCenter= $false
    }
    
        if($Filename.Name -eq "pass.txt"){
       $Filepass =$true
           
    } 
    Else{
        $Filepass= $false
    }
    
    if($Filename.Name -eq "user.txt"){
      $Fileuser =$true           
    } 
    Else{
        $Fileuser= $false
    }

}

$mail=import-csv 'C:\VMWare vCenter PID Enumeration\testemail.csv'
$e=""
Foreach($useremail in $mail){
$E+=$useremail.to + "," 
$trim=$E.TrimEnd(",") 

$emailSmtpServer = $useremail.SMTP #"smtp.gmail.com"
$emailSmtpServerPort = "587"
$emailSmtpUser = "test@gmail.com"
$emailSmtpPass = 

$emailFrom = $useremail.'From '
$emailTo = $trim.TrimEnd(",") 

$emailMessage = New-Object System.Net.Mail.MailMessage( $emailFrom , $emailTo )
$emailMessage.Subject = "My test mail $($Env:COMPUTERNAME)" 
$emailMessage.Body = "Hi Hello Test mail Only"
$SMTPClient = New-Object System.Net.Mail.SmtpClient( $emailSmtpServer , $emailSmtpServerPort )
$SMTPClient.EnableSsl = $True
$SMTPClient.Credentials = New-Object System.Net.NetworkCredential( $emailSmtpUser , $emailSmtpPass );
$SMTPClient.Send( $emailMessage )

}
$emailMessage.Attachments.Dispose()
$emailMessage.Dispose()

Neally · 2021-04-16T12:33:18.000Z

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don’t say “Need help” or “PowerShell Help”, actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy…

What you posted it just one long string and a pain to read, please re-post it correctly formated.

Also, what you are asking for seems fairly simple, have you tested it?

if(-not(test-path $pathToFile)){
    # code to send email
}

marlon3 · 2021-04-16T19:55:03.000Z

Hi

Here is the script,

i test it if the file is not exist. and it sent and email.

how can i re use the send mail with attachement?

Thanks

#File Locations
$fileemail = "C:\VMWare vCenter PID Enumeration\email.csv"
$fileList = "C:\VMWare vCenter PID Enumeration\ListofvCenter.txt"
$fileuser = "C:\VMWare vCenter PID Enumeration\user.txt"
$filepass = "C:\VMWare vCenter PID Enumeration\pass.txt"
#Check for Existence of Files  
$file1Exists = Test-Path $fileemail
$file2Exists = Test-Path $fileList
$file3Exists = Test-Path $fileuser
$file4Exists = Test-Path $filepass

#Email List
$mail=import-csv 'C:\VMWare vCenter PID Enumeration\testemail.csv'
$e=""

Foreach($useremail in $mail){

    $E+=$useremail.to + "," 
    $trim=$E.TrimEnd(",") 
    $emailSmtpServer = $useremail.SMTP 
    $emailSmtpServerPort = "587"

$emailSmtpUser = "test2@gmail.com"
$emailSmtpPass = "dasd"

$emailFrom = $useremail.'From '
$emailTo = $trim.TrimEnd(",") 
$emailMessage = New-Object System.Net.Mail.MailMessage( $emailFrom , $emailTo )
$attachedfile=$emailMessage.Attachments
$SMTPClient = New-Object System.Net.Mail.SmtpClient( $emailSmtpServer , $emailSmtpServerPort )
$SMTPClient.EnableSsl = $True

$SMTPClient.Credentials = New-Object System.Net.NetworkCredential( $emailSmtpUser , $emailSmtpPass );
#$SMTPClient.Send( $emailMessage )

}
If ($file1Exists -and $file2Exists -and $file3Exists -and $file4Exists)  
{
  Write-host "Required Files Exist" -ForegroundColor Green 
}  
Else   
{
  #Generate Text for Email Body  
  If (-not $file1Exists) {  
    $emailMessage.Subject = "Missing File"
    $emailMessage.Body = "Please Provide $fileemail"
  }  

  If (-not $file2Exists) { 
    $emailMessage.Subject = "Missing File" 
    $emailMessage.Body = "Please Provide $fileList"
    Write-host "ListofvCenter File not Found" -ForegroundColor Red 
    Write-Output "ListofvCenter File not Found$(Get-Date -Format MM_dd_yyyy_HH_mm)" >> $newfolder\Input_Filelogs_$(Get-Date -Format MM_dd_yyyy_HH_mm).txt
     }
  If (-not $file3Exists) {  
    $emailMessage.Subject = "Missing File"
    $emailMessage.Body = "Please Provide $fileuser"
    Write-host "User File not Found" -ForegroundColor Red 
    Write-Output "User File not Found$(Get-Date -Format MM_dd_yyyy_HH_mm)" >> $newfolder\Input_Filelogs_$(Get-Date -Format MM_dd_yyyy_HH_mm).txt
  }
  If (-not $file4Exists) { 
    $emailMessage.Subject = "Missing File" 
    $emailMessage.Body = "Please Provide $filepass"
    Write-host "Pass File not Found" -ForegroundColor Red 
    Write-Output "Pass File not Found$(Get-Date -Format MM_dd_yyyy_HH_mm)" >>$newfolder\Input_Filelogs_$(Get-Date -Format MM_dd_yyyy_HH_mm).txt
   
  }
   
  #Send Email  
  $SMTPClient.Send( $emailMessage )
    #Throw Exception to Terminate Job  
  throw "Missing Files" 
 

}

 Compress-Archive -Path $newfolder -DestinationPath $newfolder -CompressionLevel fastest
    write-host "...Done!" -ForegroundColor Green
    Start-sleep -Seconds 3

    Write-host "Sending email" -ForegroundColor Red -NoNewline
    $emailattachment ="$path\$newfolder.zip"
    $emailMessage.Subject = "See Attached File"
    $attachment = New-Object System.Net.Mail.Attachment($emailattachment)
    $emailMessage.Attachments.Add($attachment)
    $emailMessage.Body = "Please see attached report for today's run"
    $SMTPClient.Send( $emailMessage, $attachment )

$emailMessage.Attachments.Dispose()
$emailMessage.Dispose()

marlon3 · 2021-04-16T22:34:28.000Z

Hi neally,
Im now able to send mail if the compress is done.
I just move the coomand to the last part of the script.

And i have another question, how can i disable sending mail if i dont want to send results or log files?

Is there a command to set the send mail to false? Or need to add on my script
Thanks

$emailMessage.Attachments.Dispose() $emailMessage.Dispose()