Sending tab from workbook by email

Question

Hi,

I am looking for some help with sending via email specific information at country level to specific users.

My workbook contains output data and has a country identifier, I would like to separate out that data by country and then depending on the country, send an email to a recipient in that market with just their info.

In simple terms an example, my data covers Chile, Ethiopia and Singapore, I want to separate the Ethiopia data from the list and email it to Fred@ethiopia.com

Haven't yet quite got the grasp of the 'Basic table' tool or if that is the correct one to use. Can anyone assist me please?

Sample output data.xlsx

messi007 · Accepted Answer

@Bigmonki,

You can do this with formula tool in order to create a path per file

2 - Block until inrder to create the file.

3- Send then reference the file on the e-mail tool (I didn't test the option as I don't have access to the SMTP server)

Attached the workflow

Hope this helps !

Regards