Send email from Email address Field

[phongnnguyen]

Hi all,

I want to send email to  customer from my email address Field. Can I do it on Qlik sense ?

Do you have any solution please help me

Thanks a lot,

[undergrinder]

Hi Phong,

Qlik Sense haven't got this kind of feature.

I suppose the email address present in a table, you can export them into excel, and use chain mail feature of outlook if the content should different for every user.

If you need email sending at the refresh, then you can call an executable from load script that do the work.

G.

[phongnnguyen]

Thanks for your consider, I will try to do it with other ways

[nasirsaikh]

Phong, I am using Qlik Web Connector to send email to the customer on Summary level or upto 5 attachment upto 50 mb. If you need any help about the script let me know i will share the script...

[phongnnguyen]

Hi Nasir,

I really appreciate about that. Can you share with me the script ? Thanks so much again

Cheers,

[nasirsaikh]

Hi phongnnguyen,

Sorry for the late reply i was bit busy in my offices work month closing hence did not replied..

Here is the procedure for the sending mail from qlik sense through script...

1. Download Qlik Web Connector paste in the C drive and Install the services (C:\QlikWebConnectorsJune2018\BatchFiles\Install Service.bat) then check the services.msc

2. After successfully installation of Qlik Web Connector browse web page http://localhost:5555/web ‌go to Standard tab and Qlik Notification/SMTP Connector for configuration of your email.

3. Go to App script and use the below scripts.....

LET vTableNameStore= 'Email_Log';

Email_Log:

LOAD

  timestamp(now()) as TimestampSTART,

  status as status_START,

  result as result_START,

  filesattached as SendEmail_filesattached_START,

  '$(vVariable1)'  as Email_Type

  FROM [http://localhost:5555/data?connectorID=NotificationConnector&table=SendEmail&UserName=email&Password...

  Concatenate($(vTableNameStore))

  Load * From [lib://QVD (toi-bi_administrator)/$(vTableNameStore).qvd](qvd);

  STORE $(vTableNameStore) INTO [lib://QVD (toi-bi_administrator)/$(vTableNameStore).qvd](qvd);

  Drop Table $(vTableNameStore);

End Sub

Let vAttachement = Null();

Let vAlertRecipients = 'nasirsaikh@gmail.com';

Let vAlertRecipientsCC = '';

Let vRecipients = replace(replace('$(vAlertRecipients)','@','%40'),';','%3b');

Let vRecipientsCC = replace(replace('$(vAlertRecipientsCC)','@','%40'),';','%3b');

Let vAlertSubjectInputSTART = 'Sample Email Notification : ' &  ' $(vReportToDate)';

LET vAlertMessageInputSTART =

'<style>table, th, td {border: 1px solid black;}tr:last-child { background: yellow; }th, td {padding: 5px 5px 5px 5px;}h4{background-color:Silver}</style>' &

'<font face="verdana">' &

'<p>Dear All<br><br>Please find the attached ' & replace('$(vAlertSubjectInputSTART)',' ','+') & '</p>' &

'<p>*** This is an automatically generated email, please contact MIS team in case of any discrepancy ***.</p>' &

'</font>'

;

Let vSubject = replace('$(vAlertSubjectInputSTART)',' ','+');

Let vMessage = replace('$(vAlertMessageInputSTART)',' ','+');

Call StoreAndDrop(vRecipients,vRecipientsCC,vSubject,vMessage,vFromName,vFromEmail,vAttachement,vAlertSubjectInputSTART)

Still facing issue below is my contact details you can contact me on WhatsApp i will help with the images and scripts app.

+918767222202