How to send multiple email using power shell

Question

Dear All,   Is it possiable to send mutiable email through power Shell? With mail format   Subject: TEST Body: "Hello User, We noticed this site “Title of the site” (get title from excel column b) is owned by you and is unused for significant period of time. Please find the details below:   Site: https://contoso.com (get site url from column C) Deletion Date: 01/02/2018 03:16:46 Paris Time   What will happen:   On the deletion date this site and all lists, libraries, documents and subsites under the site will be permanently deleted.   What you can do about this: If you are using this site, please reply to this mail. We will wait till 7 days from now before deletion.   Regards   Please see the attached file.

Ravishankar N · Answer

Try this below code , You can send emails to multiple users by taking mail address from excel file.
$siteUrl = "https:// .sharepoint.com/"
Connect-PnPOnline -Url $siteUrl
$filePath = "F:\Ravishankar\Deployment\PSHELL\PSHELL\email_details.xlsx"
# Create an Object Excel.Application using Com interface
$excelObj = New-Object -ComObject Excel.Application
# Disable the 'visible' property so the document won't open in excel
$excelObj.Visible = $ false
#open WorkBook
$workBook = $excelObj.Workbooks.Open($filePath)
#Select work sheet using Index
$workSheet = $workBook.sheets.Item(1)
#Select the range of rows should select
$range= 3
for ($i=1;$i-le $range;$i++){
$toEmail= $workSheet.Columns.Item(1).Rows.Item($i).Text
Send-PnPMail -To $toEmail -From  "username@example.com"  -Subject  "Test Email"  -Body  "This is an Test Email"  -Password *****
}
$excelObj.Workbooks.Close()

Nanddeep Nachan · Answer

In Send-MailMessage, "To" parameter is an array. Add multiple users to array and pass it to "To" parameter.   Refer documentation here - https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/send-mailmessage?view=powershell-5.1

Sreeram MUNIRAJA · Answer

Hi, I want to send emails to multiple users by taking mail address from excel file. I know to send emails single users.   Thanks

Nanddeep Nachan · Answer

Below PowerShell might help. $cred =  get -credential   $body = “Just a test email”   Send-MailMessage -To vlad@demo.com -from noreply@demo.com -Subject  'test'  -Body $body -BodyAsHtml -smtpserver smtp.office365.com -usessl -Credential $cred -Port 587

Nanddeep Nachan · Answer

Please see this article for email notification using PowerShell https://www.c-sharpcorner.com/article/office-365-automation-e-mail-notification-using-powershell-script-in-office-365/