topic Automation - Send Email with Excel file in Qlik Automate

Automation - Send Email with Excel file

Camille35 — Thu, 28 Dec 2023 09:03:41 GMT

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 — Thu, 28 Dec 2023 14:09:59 GMT

salmankojar — Tue, 02 Jan 2024 05:35:40 GMT

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

Camille35 — Wed, 03 Jan 2024 13:46:12 GMT

Hi,

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

Have a good day !