Hi,
I have a process that im unable to get working and wold like advice on the processes
I have a dataset containing a number of records, each with a user and their email address. There are multiple records for each user,
The requirement is to identify each unique user in the data and send them an email detailing all the records relating to them. The users could change each time the process is run so i havent set any filters with their names.
My thoughts were to create a loop to go through a list of users, filtering their records out and sending the email before moving onto the next name on the list.
This would keep going round until there are no names left in the list.
I have used the statistic calculator to identify the users and have used the HTML report generator and emailer for the the end of the process but would like some help explaining how the loop should be set up (if this is the best way to do it) and how i can move to the next person in the list each time.
Thanks