Lease Email

<#
.SYNOPSIS
    Email Manager's their list of upcoming lease PC's
.DESCRIPTION
    Emails managers from a csv with the Lease notifications.
.EXAMPLE
    N/A
.INPUTS
    N/A
.OUTPUTS
    N/A
.NOTES
    File Name  : LeaseEmail.ps1
    Author     : XXXX
.LINK
    N/A
.COMPONENT
    N/A
.ROLE
    N/A
.FUNCTIONALITY
    N/A
#>

[cmdletbinding()]
param(
    [string]$from = 'Jim Jones <jim.jones@email.com>',
    [string]$to = 'Billy Bob <billy.bob@email.com>',
    #[string]$cc = ''Jim Jones <jim.jones@email.com>',
    #[string]$bcc = 'Jim Jones <jim.jones@email.com>',
    [string]$subject = 'New Lease',
    [string]$smtpServer = 'email.server.local',
    [string]$respondDate = ((Get-Date).AddDays(7)).ToShortDateString(),
    [Parameter(Mandatory=$true)][string]$csvPath
    )
If ($csvPath -like "*\"){
    $path = $csvPath + "leaseExport.csv"
}
Else {
    $path = $csvPath + "\leaseExport.csv"
}

[object]$importData = Import-Csv $path

$managersList = $importData.Manager | Select-Object -Unique

Foreach ($mgr in $managersList){
    $pcList = $importData | where{$_.Manager -eq $mgr} | Select-Object ServiceTag, Name, DeptNum, Model, Type | ConvertTo-Html
    $mgrFName = (Get-ADUser $mgr).GivenName
    #$to = $importData | where{$_.Manager -eq $mgr} | Select-Object managerEmail | Select-Object -First 1
    #[string]$cc = "'" + (($importData | where{$_.Manager -eq $mgr} | Select-Object EmailAddress).emailaddress -join "', '") + "'"
    $cc = ($importData | where{$_.Manager -eq $mgr}).emailaddress -join ", "
    #$cc = @(($importData | where{$_.Manager -eq $mgr} | Select-Object EmailAddress).emailaddress)
    #$cc = 'email2.user@email.com', 'email2.user@email.com', 'email2.user@email.com'
    $body = ('
<p>Hello ' + $mgrFName + ',</p>
<p>Below is a list of computers in your department that are schedule for lease replacement. Please respond with any CHANGES to our recommendation. If I do not hear from you by ' + $respondDate + ', I will move forward with ordering an equivalent PC to what is listed below.</p>
<h2>Department Computers due for Replacement</h2>
<p>' + $pcList + '</p>
<p>Note: Blah, Blah, Blah.....')

    Send-MailMessage -To $to -CC $cc <#-Bcc $bcc#> -From $from -Subject $subject -Body $body -BodyAsHtml -SmtpServer $smtpServer
}