Plugin / Software to email all teachers of a specific student

[AllSaintsAcademy]

Hi All,

 

I need to get a piece of software that will allow me to give the staff a quick way of emailing all the teachers of a specific student without having to lookup which teachers actually teach that student. I have used something like this in a previous school, but can't find the details now. The software I had in mind took an extract from SIMS via a report / csv and the staff used a web page to send the email - all replies then go directly back to the Outlook inbox of the sending member of staff.

 

Any ideas gratefully received!

 

Thanks,

 

CJ

[knightrider]

You can do this via running a report from SIMS and it opens up an email with the correct staff names in the 'To' field. I've used this but just started a new job and they dont use SIMS so cant pass it to you. @vikpaw is the man I got it from. Maybe PM him and see if he'll help you out.

 

Knightrider

[vikpaw]

Yep it's possible and I think I posted it on SupportNet or here.

There are caveats.

Staff do not normally

Have permission to see other staff emails. Also all staff will have to have an email in sims personnel area . Ideally work and main.

It works fine for admin but for lay staff you have to extract first and last name and rely on a directory lookup in outlook . Still automated tho.

If that would work then I can send you the script if you can't find it.

Travelling at the moment tho.

Wednesday ...

[vikpaw]

It was the work of a fellow edugeek that I modified I should say.

[AllSaintsAcademy]

Hi Vikpaw,

 

Many thanks for the speedy reply!

 

I can not see where that post is on here and yes it would be very useful - I will keep looking, but would be very grateful if you could either send or repost,

 

Thanks,

 

CJ

[vikpaw]

Sorry didn't get a chance to dig it out yesterday and its my weekend now.

the report definition is on SupportNet file sharing area #963 on the second page in. So you can pick it up there if you have access.

Happy to help modify If required.

[vikpaw]

Here it is.

 

It takes the first and last name of the staff member, and will dump to Outlook as a pair. It then relies on Outlook being able to look up the names in the directory, we have Exchange. Works on my Win7 box with Office 2010. Haven't tested on any other setup. You can manually hit check names or press Alt + K. The only time it fails is when, some teachers have changed their known by name, so those need to be manually altered.

 

You need to enable macros to allow the interim spreadsheet to send the names into outlook.

 

Teacher Emails of a student to Outlook.zip

[winng]

I've always used Mailfinder to achieve this and staff have always gave great feedback as it saves them so much time. It's not expensive and does a tricky job very easily.

[gumbygaz]

We use Mailfinder too, nice and easy. However, our licence has expired and they're not responding to phone calls/emails/tweets/facebook posts

Not sure what's happened, they only recently released a new version.

So looking for a replacement now. Will have a look at @vikpaw's method! Thanks

[GeekyPete]

If you don't use outlook in a properly configured Exchange/O365 environment you could add vLookup to the spreadsheet to output the actual email addresses.