[sims] Emailing exams results from SIMS

[mullet_man]

Is it worth sending an email to all pupils (school email address) and all parents now telling them that results will only be issued to school accounts and that they need to make sure now that they have access to the account?

 

That'll give you six weeks to reset 80% of the passwords, this only leaving 20% to do on the day [emoji57]

 

Edit: If you're using Teams or GSuite, would it be easier to upload a document to reach of their accounts and send a notification with a link? That way the email doesn't have to be customised and it's more secure than emailing attachments.

 

I've mentioned this that they need contacting to ask them to log on and make sure they know their password. No doubt most will wait to the morning of results day!!

 

Looks like we are going to just mail merge with no attachments so makes it a lot easier rather than needing to script something.

 

If anyone makes and shares a script though I'll take a look as I bet it might change

[bobsmith]

 

script tested and works fine - doesn't like being run on an RDP session on a server but on the desktop it's fine.

Sub Send_email_fromexcel()Dim edress As StringDim subj As StringDim message As StringDim filename As StringDim outlookapp As ObjectDim outlookmailitem As ObjectDim myAttachments As ObjectDim path As StringDim lastrow As IntegerDim attachment As StringDim x As Integer x = 2Do While Sheet1.Cells(x, 1) (the symbol for not equal to) ""       Set outlookapp = CreateObject("Outlook.Application")    Set outlookmailitem = outlookapp.createitem(0)    Set myAttachments = outlookmailitem.Attachments    path = [b]"C:\Users\Barb\Documents\statements"[/b]    edress = Sheet1.Cells(x, 1)          subj = Sheet1.Cells(x, 2)    filename = Sheet1.Cells(x, 3)    attachment = path + filename            outlookmailitem.To = edress        outlookmailitem.cc = ""        outlookmailitem.bcc = ""        outlookmailitem.Subject = subj        outlookmailitem.body = [b]"Please find your statement attached" & vbCrLf & "Best Regards"[/b]                               myAttachments.Add (attachment)        outlookmailitem.display        outlookmailitem.send                    lastrow = lastrow + 1        edress = ""    x = x + 1LoopSet outlookapp = NothingSet outlookmailitem = NothingEnd Sub

 

If anyone can get the forum to stop stripping the formatting please let me know how!

Edited July 8, 2020 by bobsmith

[coolhands]

^ is that only for outlook?

[bobsmith]

yep - but it works as a brute force way of doing it.

 

Since SLT are sticking with letting some kids in and not others I'll probably be relying heavily on this script to do the heavy lifting

[CAM]

This should be going to the students, not the parents.

 

And yes, you do need to consider the security implications. We are e-mailing to the students' school e-mail address as one mitigation.

 

Be careful of school accounts being closed for leavers, especially if students decide to not save the results and assume they can keep them in their soon to be axed inbox.

[mullet_man]

Be careful of school accounts being closed for leavers, especially if students decide to not save the results and assume they can keep them in their soon to be axed inbox.

 

We are also posting the results out, the email is going to be a here are your results until the post man delivers your official paperwork from school.

[Remiel]

I've no experience with Exams module specifically, is anyone aware of a way of printing individual students results (en-mass ideally) to individual PDFs either just using Exams Module or with a 3rd party utility?

 

The intention is to email each student their results as a PDF on the day, the actual email task can be done by the scripts linked further up the thread but i'm not clear on the best way of getting the PDFs in the first instance. In an ideal world they'd all be named using the students exam number for ease of emailing.

[mullet_man]

We are getting our PDFs from 4Matrix, am not sure on the names of the files but it should be easy to command dir > files.txt to get a list of all the file names.

[Remiel]

Sadly 4Matrix is no longer available to us, otherwise i'd look into it. If anyone has any other ideas do post them!EduGeek.net - The I.T. Professionals' life line