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. MAPPINGAEconomyBPoliticsCArtDTechnologyECompany News**mandatory, not to be selected per each person MailNameSelected topicsPeter@mail.comPeterA B CKate@mail.comKateDJulia@mail.comJuliaA C D TopicTitleDescriptionLink AXXXOOOLLLOOOLLLBXXXOOOLLL 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. How to send personalized emails with different topics.xlsx

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

How to send personalized emails with different topics.xlsx

Publish

Workflow

Input

Settings

Output

Parse

Join

Optimization

Database Connection

Documentation

Accepted answers

DavidP

This should give you one combined email per recipient

create custimised emails.yxmd

All comments

DavidP

Something like this?

create custimised emails.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703