I have a difficult problem with a database. We have patients from multiple GP Practices. We need to send these practices a report with the results for their patients, say on a monthly basis. There may be up to 80 practices.
I think I understand how to, say, send one email containing one report to one practice, or one email containing one report to many practices, but to send an individually tailored report/email to eighty practices has me stumped.
Would I need to create 80 results reports? How would I loop through the recordset of 80 practices?
If anyone has any pointers I would be really grateful.
I think I understand how to, say, send one email containing one report to one practice, or one email containing one report to many practices, but to send an individually tailored report/email to eighty practices has me stumped.
Would I need to create 80 results reports? How would I loop through the recordset of 80 practices?
If anyone has any pointers I would be really grateful.