Setting up an e-mail recipient depending on country

howyoudoing

Hi All! I need to set up the workflow depending on country of incorporation. I have 4 options to determine who the message should be sent to, you can see it in the excel file (region and recipients). The issue here is also that I have just the countries of incorporations, not regions and Im considering if  there is needed to do 4 e-mails tool on every case and then manually combine to appropriate e-mail tool or there is another option? To be honest I have no idea how to connect it. I'm attaching my initial workflow, could you please help? The final result should be to have two separate e-mails depend on values - VenueCptyLEI and Country of Incorporation as the last table in the excel file marked in yellow.

4.yxmd

output5.xlsx

CoG

You seem to need a map that identifies which countries belong to each of the available regions. Once you have that, you can join the email list to your main dataset via the map. You can then use the "Use Field" checkbox in the Email Tool for the "To:" field. I'm not sure how multiple email tools would help. Remember that the email tool sends 1 email per record in your dataset.

Hope this helps and Happy Solving!