I am building a reporting tool to sit on the back of our CRM – the tool is designed to email users a list of records they set up that have been badly coded (aka Sins)
I would like to be able to email each user their list of sins – however rather than emailing a report I would like the list of Sins to be in the body of the email. The data comes from a query called sinners and has the following fields in it:
EmailAddress (who the email goes to)
Creator (the name of the recipient)
Person (the name of the record that is badly coded)
Role (more of the record that is badly coded)
Offences (why that record is badly coded)
Each recipient can have multiple ‘Sins’ and so their email address can / is repeated in the query against each 'Sin'.
I have attached an example of the query in excel
Can anyone help?