+ Post New Thread
Results 1 to 10 of 10
Educational Software Thread, Plugin / Software to email all teachers of a specific student in Technical; Hi All, I need to get a piece of software that will allow me to give the staff a quick ...
  1. #1

    Join Date
    Jul 2011
    Location
    Cheltenham
    Posts
    5
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Plugin / Software to email all teachers of a specific student

    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

  2. #2
    knightrider's Avatar
    Join Date
    Mar 2006
    Location
    Leeds
    Posts
    85
    Thank Post
    18
    Thanked 10 Times in 7 Posts
    Rep Power
    18
    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

  3. Thanks to knightrider from:

    AllSaintsAcademy (4th February 2013)

  4. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    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 ...

  5. Thanks to vikpaw from:

    AllSaintsAcademy (4th February 2013)

  6. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    It was the work of a fellow edugeek that I modified I should say.

  7. #5

    Join Date
    Jul 2011
    Location
    Cheltenham
    Posts
    5
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    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

  8. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    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.

  9. #7

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    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

  10. Thanks to vikpaw from:

    gumbygaz (6th March 2014)

  11. #8

    Join Date
    Nov 2011
    Location
    Rayleigh
    Posts
    95
    Thank Post
    13
    Thanked 13 Times in 13 Posts
    Blog Entries
    1
    Rep Power
    7
    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.

  12. #9
    gumbygaz's Avatar
    Join Date
    Nov 2009
    Location
    Staffordshire
    Posts
    85
    Thank Post
    75
    Thanked 8 Times in 8 Posts
    Rep Power
    10
    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

  13. #10
    GeekyPete's Avatar
    Join Date
    Mar 2013
    Location
    In a cold dark server room.
    Posts
    318
    Thank Post
    22
    Thanked 76 Times in 57 Posts
    Rep Power
    25
    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.

SHARE:
+ Post New Thread

Similar Threads

  1. Software to view a couple of ip cctv cameras, and record
    By localzuk in forum AV and Multimedia Related
    Replies: 6
    Last Post: 3rd October 2011, 04:31 PM
  2. Want to set a profile for one specific student
    By speckytecky in forum Windows Server 2008
    Replies: 2
    Last Post: 1st September 2011, 02:55 PM
  3. Replies: 0
    Last Post: 20th May 2010, 08:30 AM
  4. Replies: 1
    Last Post: 26th November 2009, 10:21 AM
  5. Replies: 13
    Last Post: 6th May 2008, 09:28 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •