[[PageOutline]]

= Group Email =
Refer to ticket #52

== Requirements ==
The instructor (or admin) should be able to send a group email

A group can be: 
* Students registered in a course
* Group members in a group
* Each student

Optional:
* Email Template: User can make and use his/her own email template
 * Has ownership such as private, public, or shared among some group
* Email merge: User can make a merge field such as name, email, or etc which are automatically filled when the mail is sent
* Get Email Addresses: User can get email addresses of group and use copied email addresses with preferred email client. 

== Implementation == 
=== Recipients ===
* Recipients list in "To" field will be: 
 * Students registered in a course if user click "Email to All Students" on Course homepage
 * Group members in a group if user click "Email to All Members" on Group view page
 * Student if user click Email Icon next to student name on Group view or User index page.  
* Can add/remove additional recipients by doing similar way of adding instructors to a course.
* Not allowing manually typed email address to prevent errors with Email merge system.

=== Email Template ===
* User can add/edit/delete/view own email templates
* Can add merge fields on a template.

=== Email schedule ===
* Single/multiple schedule on email is possible.
 * Multiple schedule needs a number of times to send and interval(day(s), hour(s), or minute(s))
* Default schedule is current datetime.
* User can view emails and cancel if email is not sent yet.
* For better performance in user's view, all emails go to Email Schedule Database, then server will send emails that are ready by cron job. 

=== Database Table ===
To import tables and data, check attached file, email.sql