Hi Alteryx Community,
We are working on a knowledge sharing weekly email. For that we have a list of recipients and topics which they selected. Also we have a table with content on each topic. Let's say, a recipient 1 wants to receive emails with topics A, B, C; recipient 2 want to receive only topic D, etc. Also there are some mandatory topics which are to be included in each email.
MAPPING | |
A | Economy |
B | Politics |
C | Art |
D | Technology |
E | Company News* |
*mandatory, not to be selected per each person |
Name | Selected topics | |
Peter@mail.com | Peter | A B C |
Kate@mail.com | Kate | D |
Julia@mail.com | Julia | A C D |
Topic | Title | Description | Link | ||
A | XXX | OOO | LLL | OOO | LLL |
B | XXX | OOO | LLL | ||
C | XXX | OOO | LLL | ||
D | XXX | OOO | LLL | ||
E | XXX | OOO | LLL |
The question is how to set a workflow so that it combines the information from the list of selected topics and send appropriate content to each recipient.
Just in case, I attached an excel file with the tables below (as an example).
Thank you in advance! Even a little bit of your help would be highly appreciated for our automation project.
Solved! Go to Solution.
Hi David,
Looks nice, thank you!
But is it possible to send only 1 email per each person with different topics combined together? It seems like in this workflow multiple emails with each topic would be sent to each person.
User | Count |
---|---|
59 | |
24 | |
24 | |
21 | |
21 |