Help Required on Mass Letter Creations

[Madhu_Sudhan]

Hello Team,

Any Flows which can helps us to create mass letters based on the Excel data and Word template.

Regards

[thor_landstrom]

Hello @Madhu_Sudhan,

What kind of data do you have on your Excel? Is it a list of emails and their names? If so, you can use a loop after reading in your excel document to loop through each email to send and by passing all your necessary data via flow variable to the Send Email node. I have replied to a similar question in this thread below:

auto send email with different attachments per recipients

Hello @huynhduc, You can use the ‘Send Email’ node for this. You can do something like so in the workflow where you store the emails you want to send with their corresponding attachments location like: [image] Then once it is organized like so, you can run a variable loop start to pass each row as a variable so you can set them in the ‘Send Email’ node. [image] The workflow should generally look like this [image] Where we just loop over the table and fetch it row by row so we can pass …

But the main idea would be that you should be looping over your table you read in after you use your excel reader.

For your word template, easiest way to handle that would be to do as this other user mentions:

HTML email template to use in knime email

Hi @natanzi, not sure if i understood your question correctly. You can Insert your normal company html template to the KNIME Email node or just create a new email e.g. in Outlook with the exact layout and text you want -> then just copy & paste it into the Email node. Then set everything you want to have variable through flow variables e.g. just the number of your KPI or a whole html part of the mail

Hope this helps,
TL