##########################################################################
#                      Notification v 1.0
#
# Powershell script to email a notification to select people
#
# Notification v 1.0
# 1. Imports a CSV file that contains the following columns
#    a. CSVColumn1 (email address)
#    b. CSVColumn2 (recipients name)
#    C. CSVColumn3 (specific info pertaining to each person)
#
##########################################################################


$File = "C:\PS_TMP\mass_email\Users_TO_Email.csv"
Import-CSV $File | ForEach-Object {

$SMTPServer = 'smtp.<Domain>.com'
$From = 'noreply@<Domain>.com'
$To = $_.CSVColumn1
$Subject = '<Email Subject>'
$Body = ('<FONT FACE="tahoma">' + $_.CSVColumn2 + ', </FONT>')
$Bodycommon = '

<FONT FACE="courier">
<br></br>
<i>
Some text that you want the person to see
<br></br>
More Text for them to read  <font color="red" size="3">' + $_.CSVColumn3 + '</font>
<br></br>
One Big paragraph
Text
text
test
<br></br>
Thank you,<br></br>
Your name
</i>
</FONT>
'

Send-MailMessage -SmtpServer $SMTPServer -From $From -To $To -Subject $Subject -BodyAsHtml  ($Body + $Bodycommon)

}
[System.GC]::Collect()