[ms office - 2013] How setup so staff can email teachers of a given student?

[adgethi1]

Can anyone tell me how to set it up so staff in school can email the teachers of a given student through Outlook - we have setup groups so whole classes can be emailed but was hoping there is a way of integrating through SIMS to bring up the teacher of students without having to search each one in turn. This is in a bid to help reduce whole staff emails which are a real problem in my school.

[howartp]

I'm assuming you're on an Exchange server?

 

We have the various groups for classes, like you - these are generated from Powershell every night.

 

However we don't do 'Teachers of' because it would take a number of hours to loop through everyone, and I don't want another 1700 distribution lists in Exchange.

 

If you wanted to do it, you need a SIMS report that exports to CSV every night (using CommandReporter) and a powershell script that creates (if not exist), empties (rather than deletes, so the GUID stays the same) then populates, each group.

 

Peter

[Edu-IT]

We have the various groups for classes, like you - these are generated from Powershell every night.

How is that achieved exactly?

[howartp]

How is that achieved exactly?

The same as my previous post:

If you wanted to do it, you need a SIMS report that exports to CSV every night (using CommandReporter) and a powershell script that creates (if not exist), empties (rather than deletes, so the GUID stays the same) then populates, each group.

 

Sample of script:

 

$ClassNamesFile = import-csv -Path c:\Importer\List_ClassNames.csv -OutVariable string

foreach ($ClassName in $ClassNamesFile)

{

$FullAlias = NoSpaces $ClassName.Class

$FullListName = $ClassName.Class

Write-Host $FullListName `($FullAlias`)

New-DistributionGroup -name $FullListName -samAccountName $FullAlias -alias $FullAlias -type Distribution -OrganizationalUnit "OU=AutoDistributionLists,DC=scraven,DC=internal"

}

 

$Classfile = import-csv -Path c:\Importer\List_Classes.csv -OutVariable string

foreach ($Class in $ClassFile)

{

$FullAlias = NoSpaces $Class.Classes

$FullListName = $Class.Classes

Write-Host $FullListName `($FullAlias`): $Class.Student.padLeft(6,"0")

Add-DistributionGroupMember $FullAlias -member $Class.Student.padLeft(6,"0")

}

[psydii]

Or just use sims to send the message.