Email all teachers linked to a pupil

[markwilfan]

Thanks for this. I've no idea if the school has InTouch - I'll check on Monday. Any idea what InTouch would cost per annum for just under 2000 pupils.

I'll put money on it that salamander will be cheaper and is just incredible. Support is fantastic too

[benIT]

+1 for salamander. We have lots of groups with decent naming conventions so staff can find them with ease. Lots of groups makes no difference and helps with staff time. 30 seconds saving may not sound much but for each teacher over the year for every email is a lot, plus the wasted time otherwise for teachers reading emails not relevant to them. Do a quick bit of maths it will amaze you. Easily pay for salamander!

[knightrider]

Years ago I created a report in SIMS which did this. You ran it in SIMS & up popped a dialogue box. Type the name of the student & an email opened with the names of all the staff who taught that student in the To field.

I’ll see if I can dig it out again.

[Ditto]

Years ago I created a report in SIMS which did this. You ran it in SIMS & up popped a dialogue box. Type the name of the student & an email opened with the names of all the staff who taught that student in the To field.

I’ll see if I can dig it out again.

Would be much appreciated to see this.

[panosthegreat]

We just have a report in SIMS as someone above described, you type in their legal surname and forename and it'll bring up all their teachers. I've set mine up to ignore class descriptions that are blank (that takes away the House leaders and Form Tutors but may not be needed for your schools). We just copy/paste the column of email addresses straight into Outlook after this runs. Takes less than a minute. Staff that need this regularly can pin it to their home pages too

 

I've attached our report Teachers of a student search.zip here, unzip and import it into SIMS, not sure if that'll work for everyone depending on what you've input into SIMS I guess

 

To create this manually:

Data Area: set it to 'All Students' (I guess this could be current, but we sometimes use this to send out timetables for new/future students)

Data Fields we use are: Student Name & Reg, then under 'Classes' we put Class Teacher, Class Description, Subject, Work Email

(I've put a filter on Classes to only show where the Subject is not null, but this is just to take away the house leaders we have here, may not be relevant to your schools)

Filter Students: Where Legal Surname equals (and leave value blank), then tick 'prompt at runtime', AND where legal forename equals (and leave value blank), then tick 'prompt at runtime'

Specify Effective Date: I've set it to 'Supply Effective Date at Runtime' as we can then search future students to warn staff about new timetables, but I guess you can just leave that to 'today'

Then for output, set it to Excel, and untick the 'Go Straight to Print Preview' box as that's annoying

 

 

 

 

I have a similar one to pick out emails of teachers of a specific year group too if anyone needs? it's basically the same but with a filter for year group that runs at run time rather than legal forename/surname

[asc]

We achieved this using Wonde to pull data from SIMS and built our own tool using Laravel (PHP). Find pupil in the system and then we have a field containing teachers' emails comma separated which you just copy and paste into the Gmail to: box.

An on-the-cheap option if you're willing to do some coding!

[vikpaw]

Defo recommend Salamander because you get way more for your money than fixing this one problem.

 

All the syncing is taken care of and updates.

 

If you did want to go your own way, as others have mentioned you can write a SIMS report to partly do this. I’m pretty sure I had one with a macro embedded that would open outlook and populate the emails for you. It was 95% successful depending on the name conversion against the exchange directory ( too many staff not using their real names! ). I probably built it off the back of someone else’s report.

 

There should be a thread on it here as it was shared.

[ITGURU]

We have MintClass for seating plans and apparently it can be done using that.

[knightrider]

Would be much appreciated to see this.

 

DM'd you.

[vikpaw]

The old thread I mentioned here, not sure if it would still work: http://www.edugeek.net/forums/educational-software/108166-plugin-software-email-all-teachers-specific-student.html#post929690

[sister_annex]

I wrote a powershell script for this, it's still in testing but essentially takes a sims report, exports it to csv, and generates/ updates / removes groups as needed. Have it set up to run on a schedule, takes about half hour for 1500 group changes...

 

I created a separate address book policy in exchange to keep the GAL clear

 

It's not the most elegant script by any stretch but it seems to work for us