get all txt files $filenameAndPath = code please help

• juliava

  SSC-Addicted

  Points: 444

  More actions

  May 9, 2024 at 2:43 pm

  #4420051

  Hello

  I need to get txt files from directory and send email, when I put name of the file my code is working, but I need to get all txt files from directory and dont know which to use,please help me thank you here is my code: This code is working,just not sure how select all txt and email

  # Email the TXT

  $EmailFrom = "test@yahoo.com"

  $EmailTo ="john1@yahoo.com"

  $Subject = "Testing"

  $Body = "Hello,nnPlease find attached a report .nnThank You,"

  $SMTPServer = "smtp.office365.com"

  $SMTPPort = "111"

  $filenameAndPath = "\\John\Data\test\Test1.txt"

   

  $smtp = New-Object System.Net.Mail.SmtpClient($SMTPServer, $SMTPPort)

  $smtp.EnableSSL = $true

  $smtp.Credentials = New-Object System.Net.NetworkCredential('yyy@yahoo.com' , 'yyy');

  $message = New-Object System.Net.Mail.MailMessage

  $message.Subject = $Subject

  $message.Body = $Body

  $message.From = New-Object System.Net.Mail.MailAddress($EmailFrom)

  $message.To.Add($EmailTo)

  $attachment = New-Object System.Net.Mail.Attachment($filenameAndPath)

  $message.Attachments.Add($attachment)

  $smtp.Send($message)

   

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  May 10, 2024 at 3:10 pm

  #4420323

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Ken McKelvey

  SSCoach

  Points: 18842

  More actions

  May 11, 2024 at 9:14 am

  #4420511

  As PowerShell can have problems with UNC paths try something like:

  New-PSDrive -Name "TxtFiles" -PSProvider "FileSystem" -Root "\\John\Data" | Out-Null
  $Files = Get-ChildItem TxtFiles:\test\*.txt
  Foreach ($File in $Files) {
      $attachment = New-Object System.Net.Mail.Attachment("TxtFiles:\test\$($File.Name)", 'text/plain')
      #$attachment = New-Object System.Net.Mail.Attachment($File.FullName, 'text/plain')
      $message.Attachments.Add($attachment)
  }
  Remove-PSDrive -Name "TxtFiles"