Custom recall report...

[khdilger]

I just bought a practice and would like to send postcards or letters to a set of people. Is there a way to generate a custom recall report that will allow me to use the recall functionality to print address labels and or postcards?

I have come up with the following query as an example. The basics... I want to find patients right now who were due between Jan 1 2010 and July 1 2010 who did not have an appointment or are not currently appointed. What I need to do is use that list of patients in the Appointment List section to generate recall letters etc...

select recall.DateDue, recall.DatePrevious, patient.* from recall JOIN patient ON recall.Patnum = patient.Patnum where recall.datedue > date('2010-01-01') and recall.datedue < ('2010-07-12') and recall.recalltypenum = 1 and recall.patnum not in (select patnum from appointment) order by recall.datedue asc

Any help appreciated.

[khdilger]

I think I found what I was looking for in the manual (go figure)...