Send bulk of emails from a table

Question

hi there :)

I was wondering how to send bulk of emails from a list. What i want to archive is in the body of email, take first line as example:

hi Ally,

please see below for your result:

KPIApril resultMay result1007075

Please see the attached list.

Appreciate your help.

list.xlsx

KGT · Answer

You'll need to construct the body into a field, most likely with a combination of Text and Table tools from the reporting category.

Check "Help > Sample Workflows > Describe.... > Create Summary tables for a report" for an example of working with these reporting tools.

Lastly, you can use the email tool from Reporting category. This will need some configuration to get your SMTP address etc.

Note: You could do all this and then find your IT has shut off SMTP from employees computers. So I would test a simple email first.