Sunday 1 April 2018

Using MailMerge to send progressive results to students

In my almost five years of teaching, I have been using this method of keeping my classes updated of their progressive results every semester. We have only started using Moodle Gradebook two years ago (well at least for me) but I still find myself having to resort back to this method of updating my classes of their progressive results.

If you are like me, wanting to make the most of what basic tools like your MS Word, Excel and Outlook can offer then this post is for you. (I am assuming you are using a Windows OS with MS Office installed already) In this post, I go through step by step on how I create a grade book for my class and send the results to their emails using a method called MailMerge.

There are two things that we need to do;
  • Task 1: Creating a grade book in MS Excel
  • Task 2: Using MS Word to create a standard template for the mail merge ready to send the results from the Excel grade book.
Task 1 Creating a grade book in MS Excel

For this tutorial we will just use dummy test results, names and emails.

Step 1 Open a blank Excel file. Create seven columns and put in the column headings as First_name, Second_name, Email_add, Test1, Test2, Test3, Total

Step 2 Add at least three to four records of dummy details. One email can be your own email or a second email you use. This will be an email which you will use to verify that your mail merge is successful and you are sure that students will receive the assessment report. Here is a sample of my gradebook. Make sure to save the Excel file somewhere.

Gradebook in Excel
You will notice here that all the emails here are real emails except for the last one. This is so that I can demonstrate at the end that the mail merge was successful and I posing as a student have received the report.



Note: It is important that your column headings must be as descriptive as possible of the information they contain plus your labels of the table must all be in the same row otherwise Excel may not pick it up in the mail merging.

Task 2 Using MS Word to create a standard template for the mail merge ready to send the results from the Excel grade book.

Step 1 Open a blank word document and create a standard template for sending the grades. I call this an assessment report. Here are files that I used for this tutorial.
You can edit and make it look more professional to your liking. At least it is a formal looking report of some sort which your students will receive containing their marks.
Template for your assessment report
Step 2 From the word document go to the Mailings tab, click on Select Recipients, select Use an Existing list. Browse to where you saved the Excel grade book and select it.

Select Recipients, Use an Existing list.
Select the grade book excel file
This dialog box will pop up asking you to Select Table. Remember that in Excel you can have several different worksheets. You have to choose the worksheet in which your grades are. For this example, we have only one worksheet which is Sheet1 by default. Ensure that the First row of data contains column headers option is checked. Click on OK.


Now we're ready to start the mail merge.

Click on Start Mail Merge and select Email Messages

Here is how you start inserting the fields and finally sending the email reports.



I hope this tutorial will be of great help to you.

Let me know in the comments section about some ways in which you engage with your students regarding their assessment items.

No comments:

Post a Comment