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

[AnastasiiaLiptuha]

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

Mail	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.

[DavidP]

Something like this?

[AnastasiiaLiptuha]

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 · Accepted solution]

This should give you one combined email per recipient