I need to be able to send automated emails to recipients (responsible_person) highlighting specific details, via a report.
The fields of importance ae
[Audit_no]
For each audit i.e. [audit_no] there will be recommendations made i.e. [recommendation_no] - these are linked - showing [recommendation_details] and [responsible_person]
So for example, for audit_no 27 - there are 5 recommendations - 3 are responsible to R.Hughes and 2 to J.Cliff
I want R.Hughes to receive his 3 only and J.Cliff to receive her 2 only by email, either through a report or direct in the email
I have another table which lists all potential responsible people and a valid email address associated to it - the table has fields responsibleid, responsible, email
Any help much appreciated
The fields of importance ae
[Audit_no]
For each audit i.e. [audit_no] there will be recommendations made i.e. [recommendation_no] - these are linked - showing [recommendation_details] and [responsible_person]
So for example, for audit_no 27 - there are 5 recommendations - 3 are responsible to R.Hughes and 2 to J.Cliff
I want R.Hughes to receive his 3 only and J.Cliff to receive her 2 only by email, either through a report or direct in the email
I have another table which lists all potential responsible people and a valid email address associated to it - the table has fields responsibleid, responsible, email
Any help much appreciated