plambrechtsen/BulkEmail.csv

## BulkEmail.csv

          
            to
            cc
            firstname
            fullname

            
              peter@email.local
              shared@email.local; manager@email.local
              Peter
              Peter Lambrechtsen

## BulkEmail.ps1
$csvpath = ".\BulkEmail.csv"
$attachment = ".\Attachment.pdf"
$sender = 'shared@email.local'

Function Send-Email {
	param (
		[String]$to,
		[String]$cc,
		[String]$firstname,
		[String]$fullname
	)

	$body = @"
<html>
	<body style="font-family:verdana">
		<h1>M&#333;rena $($fullname)</h1><br/>
	</body>
<html>
"@

	$Outlook = New-Object -ComObject Outlook.Application
	$mail = $Outlook.CreateItem(0)
	$mail.subject = "IMPORTANT: Spam for $($firstname)"
	$mail.SentOnBehalfOfName = $sender
	$mail.SendUsingAccount = $Outlook.Session.Accounts | where {$_.DisplayName -eq $sender}
	$mail.sender = $sender
	$mail.To = $to
	$mail.Cc = $cc
	$mail.HTMLbody = $body
	$attach = Get-ChildItem $attachment
	$mail.Attachments.add($attach.FullName)
	$mail.Send()
}

Import-Csv $csvpath | Foreach-Object {
	Send-Email $_.to $_.cc $_.firstname $_.fullname
}
	to	cc	firstname	fullname
	peter@email.local	shared@email.local; manager@email.local	Peter	Peter Lambrechtsen
	$csvpath = ".\BulkEmail.csv"
	$attachment = ".\Attachment.pdf"
	$sender = 'shared@email.local'

	Function Send-Email {
	param (
	[String]$to,
	[String]$cc,
	[String]$firstname,
	[String]$fullname
	)

	$body = @"
	<html>
	<body style="font-family:verdana">
	<h1>Mōrena $($fullname)</h1><br/>
	</body>
	<html>
	"@

	$Outlook = New-Object -ComObject Outlook.Application
	$mail = $Outlook.CreateItem(0)
	$mail.subject = "IMPORTANT: Spam for $($firstname)"
	$mail.SentOnBehalfOfName = $sender
	$mail.SendUsingAccount = $Outlook.Session.Accounts \| where {$_.DisplayName -eq $sender}
	$mail.sender = $sender
	$mail.To = $to
	$mail.Cc = $cc
	$mail.HTMLbody = $body
	$attach = Get-ChildItem $attachment
	$mail.Attachments.add($attach.FullName)
	$mail.Send()
	}

	Import-Csv $csvpath \| Foreach-Object {
	Send-Email $_.to $_.cc $_.firstname $_.fullname
	}