Patient email list

(system) #1

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?

(system) #2

visolveemr wrote on Tuesday, June 23, 2015:


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.


(Chrys Ostrander) #3

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

(Stephen Waite) #4

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

(Chrys Ostrander) #5

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