We have a Loyalty table that holds up to 10 friends/family members' names and birthdays.
I want to be able to send an email that looks at all those records and pulls out the family member and birthday that meets my criteria (i.e. birthday is in 14 days) as well as enrich the email with that guests' personalised information (i.e. name or age).
i.e. I have the Query I want, which will find anyone's birthday 14 days from now:
but how do I find out which of the 10 meets that criteria so it can be enriched by a delivery?