TSENDMAIL Multiple Reciepents with multiiple attachments

Four Stars

TSENDMAIL Multiple Reciepents with multiiple attachments

Hi Team,

 

I am trying to do Email Bursting 

I have Multiple files in Folder (Tfilelist)

I have email ids in Excel

I am able to send multiple emails to multiple users,but system is sending same attachment to all the users

Excel has file name,email id

i want to pick email id from excel and add attachment related to that email 'id

Please suggest

 

Thanks

Sharath

Highlighted
Eight Stars

Re: TSENDMAIL Multiple Reciepents with multiiple attachments

 Have you got differents status for each line (for one sheet) ?
Or each excel file has one status : approved - unapproved
So for each sheet or for each line (depend on), you have to catch the value of 'time status' & send a mail.
For this you I will use a tFlowToIterate (that put flow value in globalMap) and after that link with trigger conditionner 'run if'.
if TimeValue equals approved => send mail 1
otherwise => send mail 2
https://help.talend.com/search/all?query=tFlowToIterate&content-lang=en
https://help.talend.com/search/all?query=Connection+types&content-lang=en

Warm Regards,
Please don't forget to give Kudos if it resolves issue, and if you think its Apt you can also mark its as solution.
Four Stars

Re: TSENDMAIL Multiple Reciepents with multiiple attachments

Actually i have file names and email in excel,using Tflowiterate i am pulling email as global variable in "TO" address as ((String)globalMap.get("row7.EMAIL"))

Folder contains file names-->using file path i have defined global variable in attachments as ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))

But system is sending emails to mutliple users but picking same attachment for everyone

System should pick  each file as attachment and take email id for that particular file name from excel and send emails

Please suggest

 

Regards,

Sharath

Tags (1)
Four Stars

Re: TSENDMAIL Multiple Reciepents with multiiple attachments

Please find the attachment

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now