Exporting entire pt list

[aussiedentist]

Need to export a whole file of pt names, ph numbers and emails

WIll be contacting everyone to come to our opening party!

Any ideas how i can do it easily?

[JimZ]

If there isn't a query on the Query page of the manual, this may work:

select LName, FName, HmPhone, WirelessPhone, Email from patient
WHERE PatStatus=0
ORDER By LName

Or this one for a full list:

SELECT patient.LName,patient.FName,patient.Address,patient.Address2,patient.City,patient.Zip,patient.HmPhone,patient.Birthdate,patient.MedUrgNote FROM patient ORDER BY LName

I used to run the second query at the beginning of the month and export it into a spreadsheet to keep on my phone for emergencies.
Jim