How to email associated files to recipients using Gmail

[Preshan]

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   

[Luke_C · Accepted solution]

Hi @Preshan 

You can use the email tool. You'll need to get the smtp info from your gmail account, then you can specify that your 'to' field is from the business email field, and also add an attachment and specify that it should be pulled from the filepath field in your data. 

[TonyA]

I just went through this and here's what worked for me:

You do need to make sure that the "Allow less secure apps" setting is "ON". You set this at https://myaccount.google.com/lesssecureapps. Also, the username can be your full email address or just the name (without "@gmail.com").