Patient email list

docaltmed wrote on Monday, June 22, 2015:

How do I produce a list of patient names and emails, preferably one
which can be exported as a csv file?

visolveemr wrote on Tuesday, June 23, 2015:

Hi,

You may need to fine tune the report under Reports->Clients->List to pull the email address of patients. Currently it list out the patients, their address and phone numbers which could be exported as CSV.

Thanks,
ViSolve
services@visolve.com

Would it be possible to give us a hint where to go to ‘fine tune’ the fields included in the client list?

hi @Chrys_Ostrander, you could add the email field to the sql statement, openemr/patient_list.php at master · openemr/openemr · GitHub

and then add the sql to the report, openemr/patient_list.php at master · openemr/openemr · GitHub

this is the development tip of code so your version like 5.0.1 will vary slightly and not have support for the csvEscape() function

Thanks. I’ll give that a try. Mine is v5.0.2.