Neil
If you can run a query run this query :
SELECT usr.firstname, usr.lastname, usr.email, c.fullname
FROM mdl_course c
INNER JOIN mdl_context cx ON c.id = cx.instanceid
AND cx.contextlevel = '50'
INNER JOIN mdl_role_assignments ra ON cx.id = ra.contextid
INNER JOIN mdl_role r ON ra.roleid = r.id
INNER JOIN mdl_user usr ON ra.userid = usr.id
WHERE r.name = 'Student'
ORDER BY usr.firstname, c.fullname
Best regards