Author Posts

September 3, 2015 at 1:55 pm

Hi Experts,

I have an csv file which contains a field named "Primary Owner" and it contains email id's of users. I would like to send email to those users in single email using powershell. How can i do that.

PrimaryOwner
———————–
abc@yammer.com
cdf@yammer.com

Normally i will define the users in To section like below.. but here, the ccsv file content will change in each time

$to = "abc@yammer.com","cdf@yammer.com"

Send-MailMessage -SmtpServer server1 -To $to -From $from -Subject $subject -Body $body -BodyAsHtml

September 3, 2015 at 1:59 pm

You would need to use Import-CSV to read in your CSV file and then loop through the records using a ForEach-Object something like:


Import-CSV inputfile.csv | ForEach-Object {Send-MailMessage -SmtpServer server1 -To $_.PrimaryOwner -From $from -Subject $subject -Body $body -BodyAsHtml}