We would like to send out birthday reminders (for example, in March mail something to patients with April birthdays) about the importance of annual physical exams, and also include info on various screening (pap, mammo, etc...)
In theory, I could run a query to select patients, and then click for 'Reports' and choose the letter to be mailed. The mail merge could then happen.
However, birthday month is not an available field to select on in Inquiry mode.
Maybe it is?
A work-around, in theory...
1) Inquiry for all active patients
2) Reports, then select the custom-built letter to do so MEL. Use MEL to extract birthmonth, and then have the letter do an OBSNOW to a dummy variable. For instance, {OBSNOW('TOTAL # BIRT',month}
3) This would put the birthday month in the field 'TOTAL # BIRT', assuming I am not using elsewhere.
4) Then each month, run an Inquiry on Observation (last entry) for the field 'TOTAL # BIRT' to be equal to my desired month, say '4'.
5) Reports, then select custom-built letter to print a letter for each patient and record the letter in the patient's chart.
Would this work? Are there easier ways?
Thanks.
Joe