Hi all
Can someone guide me on how to create a email process that will email files associated to a user by using reference table as shown below. It will need to be sent using a Gmail account

I will need to send each recipient their associated files and there are over 1000 recipients.
Any guidance will be greatly appreciated. Thanks