We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to send personalized emails with selected topics to each recipient?

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
AEconomy
BPolitics
CArt
DTechnology
ECompany News*
*mandatory, not to be selected per each person

 

MailNameSelected topics
Peter@mail.comPeterA B C
Kate@mail.comKateD
Julia@mail.comJuliaA C D

 

TopicTitleDescriptionLink  
AXXXOOOLLLOOOLLL
BXXXOOOLLL  
CXXXOOOLLL  
DXXXOOOLLL  
EXXXOOOLLL  

 

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.

3 REPLIES 3
DavidP
17 - Castor
17 - Castor

Something like this?

 

DavidP_0-1596060656185.png

 

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. 

DavidP
17 - Castor
17 - Castor

This should give you one combined email per recipient

 

DavidP_0-1596092289360.png

 

Labels
Top Solution Authors