I would like to generate:
1.An excel spreadsheet
2.A mail merge (preferably using HTML and using a picture)
for patients that have not attended within the last 12 months.
Your help would be much appreciated
To create a query to find patients that have not visited for some time create the followng query:
When the query is run it will ask you for a date put in 19/02/2018 and it will show those patients who have not attended since February 2018
This list of patients can then be printed which will send their details to Excel.
I hope this answers your question