Automation - Send Email with Excel file

[Camille35]

Hi everyone,

I want to send an email to people who is present in an excel file. In my Excel files, I have 2 columes : email and company.

Before send mail, I generate report for differents company.

So, I want to send report to the good personns.

If I generate a report for France , I want to send my email to all peoples with company is France in my Excel file, not others

If I generate a report for Spain, I want to send my email to all peoples with company is Middle East in my Excel file, not others

Ect ect..

Here, a screenshot of my automation.

Before all, I want to say, my file excel is link to my data model. Company in data file, is linked to company in my model.

In the block select field value, I make a selection on the company who the report is generate.

In the block list values of field, it's the list of email (normally with block field value apply, but here, all company are send to all email...)

In the block condition, I make verification between company in file excel and company of report.

In the block send mail, I send mail to the people of the company.

Thank you all

[Ray_Strother · Accepted solution]

Hello,

The below link should help you in this effort. I would focus on the "Reports" section.

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_QlikAutomation/introduction/...

[salmankojar]

How do you generate report for a particular company? from Qlik App or Qlik Automation?

[Camille35]

Hi, 

Thanks for your answers. It's OK for me.

Have a good day !