+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 21 of 21
MIS Systems Thread, SIMS - Emailing Tutor's of a Student in Technical; I have found another thread which is basically what I am trying to achieve http://www.edugeek.net/forums/mis-sy...ims-email.html Haven't been able to work ...
  1. #16
    Hayleywow's Avatar
    Join Date
    Oct 2011
    Location
    Bournemouth
    Posts
    18
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I have found another thread which is basically what I am trying to achieve SIMS - email?

    Haven't been able to work out the Macros though yet

  2. #17

    Join Date
    Jan 2011
    Location
    UK
    Posts
    13
    Thank Post
    3
    Thanked 3 Times in 3 Posts
    Rep Power
    8
    Use InTouch - it has all the features of Schoolcomms but has the added ability to be run from most of the student focused modules of SIMS. If you are logging behaviour, reward, detentions etc you can email/SIMS message/text all contacts (staff, parents, students) involved and use templates as you would sending mail merged letters home. We have ours set up to use email by default so that all receiving staff get the messages about targeted students, late registers, emergency call outs etc, straight into their outlook. Have only had it a few weeks and there were issues to start with - its is fairly resource heavily is you already have a lot of home screen widgets configured in SIMS.

    Ian

  3. #18
    pubgrub277's Avatar
    Join Date
    Jul 2010
    Location
    Newcastle
    Posts
    89
    Thank Post
    5
    Thanked 19 Times in 11 Posts
    Rep Power
    17
    I use command line reporter and excel to automate sending out weekly data to staff.
    part of the maco i use is:
    Code:
    Set OutApp = CreateObject("Outlook.Application")
                    Set OutMail = OutApp.CreateItem(0)
                On Error Resume Next
                With OutMail
                    .To = Range("H1")'Cell of the to: persons email form tutor
                    .CC = Range("I1") & ";" & Range("J1") ' People being copied in i.e heads of year
                    .Subject = "Weekly BMR Data"
                    .Body = "enter body text here"
                    .Attachments.Add ("U:\sample file.xls)
                    .send 'Or use display to preview message first
                End With
    This creates the email based on values in cells H1 for the To feild and I1 & J1 for CC. Other macros filter the list/ data and graphs and save as .pdf. the attachment part of the above macro is set to include the created file (this stops staff breaking/playing with my sheet templates) to send to staff.

  4. #19

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,887
    Thank Post
    749
    Thanked 1,466 Times in 1,218 Posts
    Rep Power
    364
    The simplest thing would be to copy the returned emails from excel into the To box, especially if this is mostly for one-offs. This does require that the emails are in SIMs, which we put in for all staff. Basically, as per the report i uploaded in the thread you found.<BR>
    If you are using schoolcomms, it does also do what you need as mentioned:

    15-11-2011-16.59.46.png

    So you have the Today's teachers of and All Teachers option, under the school members section.

    The other thing you can do is to create a mailmerge report in SIMs, when you set up the mailmerge report, you have the option to select email as the output. There is a document somewhere on how to do this, i did it ages ago as a test. Then so long as you have email as a field in the report and it's in a certain place, when you run it, it will automatically mailmerge the results to email. I'm not sure if mailmerge is going to be very reliable on Office 2010 though as there have been issues.<BR>

    I might investigate that macro'd report tomorrow. Which part of it didn't work for you? Did you get an error?

  5. #20

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,887
    Thank Post
    749
    Thanked 1,466 Times in 1,218 Posts
    Rep Power
    364
    Quote Originally Posted by vikpaw View Post
    I might investigate that macro'd report tomorrow. Which part of it didn't work for you? Did you get an error?
    Eventually got round to it. It works a treat. Dumping the work emails for staff who teach selected pupil into an outlook email ready for sending. Saves that manual step of copy pasting the names.

    Must go and add some rep for that one.

  6. #21

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,887
    Thank Post
    749
    Thanked 1,466 Times in 1,218 Posts
    Rep Power
    364
    Just found that, as per the author, it's only going to work for staff with higher level access to SIMS, i.e. the staff contact info. As regular teachers don't have this, it doesn't quite fit the function.
    I've modified mine to bring back the first and last names and concatenate them. This when fed to Outlook, gets looked up in the global address book, and now works for any staff.



SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

  1. [SIMS] SIMS - email?
    By andykemp in forum MIS Systems
    Replies: 65
    Last Post: 4th October 2012, 11:33 AM
  2. Sims Discover or Medal of Honour?
    By Banjo in forum MIS Systems
    Replies: 37
    Last Post: 3rd November 2010, 07:20 AM
  3. [SIMS] has lost set lists for students!! [Solved]
    By bossman in forum MIS Systems
    Replies: 4
    Last Post: 7th June 2010, 12:50 PM
  4. SIMS - and the start of Academic Year 2008/09
    By Toby.Belfield in forum MIS Systems
    Replies: 18
    Last Post: 7th September 2008, 07:53 PM

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
  •