How to send bulk email notification to users personally from Koha (Using the Emailer Plugin)

1. To set up the Koha plugin system you must first make some changes to your installation.
Visit the Video

sudo gedit /etc/koha/sites/library/koha-conf.xml

In the xml file Change <enable_plugins>0<enable_plugins> to

                                          <enable_plugins>1</enable_plugins>

2. Download the Emailer Plugin kpz file.

Sample Message 'Student Library Card Collect - reg.'

3. Go to: Koha Home › Tools › Tool plugins› Upload Plugin 'Patron Emailer.kpz' 

4. Plugin 'Patron Emailer' Click Actions 'Configure' 

Copy and paste the following queries in email text.

Dear
        [% surname %] ([% cardnumber %]),

[% messages %]

User Name: [% username %]

Password: [% password %]

Ensure the message is setup as you wish

5. Type your message and Save the results as .csv format (Download Sample Format)

6. Plugin 'Patron Emailer' Click Actions 'Run tool' (choose file)

7. Please upload your messages.csv file and  click 'Send Emails'

8. Check your Gmail account 'Sent list' (Your Message Successfully sent)

Book Overdue Message

Dear 

        [% surname %] [% cardnumber %],

Title of the Book:  [% title %]

Author: [% author %]

Barcode: [% barcode %]

Book Due Date: [% DateofDue %] 

No of days overdue: [%daysoverdue %] 

[% LibraryName %] 

Reference: https://github.com/bywatersolutions/koha-plugin-patron-emailer