Repeating data from recordset in each email
I am setting up a facility to email customers in a database. Each customer has a number of records relating to them which I want to show in their email.
I know how to send to recipients from the recordset but how do I create a recordset in the email template which is filtered by the current email recipient so I can then list all their related data?
I'm sure it's straight forward and have looked through this forum but I can't find the method.
Many thanks in anticipation