Of the common practice systems this is the least fiddly: one report does the filtering and the export in the same place. Paths below were checked against Patterson's support documentation.
-
Open the Patient Master report
The Patient Master report is the patient list with the filters you need attached to it — status, visit dates and the address fields all in one place.
-
Set the last visit date range
Click into the Last Visit Date box and enter the range you are after. This is the filter that defines lapsed: everyone whose last visit falls before your cut-off.
-
Decide what to do with inactive status
Patient status is a separate filter — unchecking Inactive removes those records from the report. Whether you want them is a judgement call: some practices mark people inactive the moment they miss a recall, others only when they have genuinely left.
-
Save it as a CSV
With the report on screen, right-click and choose Save Data As, then set Save as Type to Comma Delimited File (*.csv) — or Microsoft Excel File (*.xls) if you would rather open it in Excel first. Both import fine.
-
Open it carefully
If you open the CSV in Excel to check it, watch the ZIP column: Excel will silently turn 02108 into 2108 across the whole column and those rows will not address correctly. Import that column as text, or skip the round trip entirely.
Once you have the file
Check the export actually carries street, city, state and ZIP — recall reports are built for phoning people and often ship without them. Then clean it before you upload: collapse households, drop anyone flagged do-not-contact, and repair any ZIP your spreadsheet stripped a leading zero from. What the file needs covers the columns we look for.