Email Alert and trigger

polisetti — Tue, 16 Sep 2014 09:43:08 GMT

Hi All,

We had a requirement like,On a sheet there will be one Email button.

When user clicks on that button it should redirect user to the enter some email body and the email address and when user clicks on OK, it should send the mail to the respective recipients with the current sheet screen shot as attachment.

Can anybody help us with how we can implement it in QlikView.

Any help would be appreciated.

Regards,

Jaswanth.

Re: Email Alert and trigger

Anonymous — Tue, 16 Sep 2014 14:20:01 GMT

you need to use VB Macro and Button Action to fire the macro.

Here is the VB sample to send email:

strSMTPFrom = "no-reply@yourcompany.com"

strSMTPTo = "helpdesk@yourcompany.com"

strSMTPRelay = "smtp relay server name or IP address"

strTextBody = "Body of your email"

strSubject = "Subject line"

strAttachment = "full UNC path of file"

Set oMessage = CreateObject("CDO.Message")

oMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2

oMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = strSMTPRelay

oMessage.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25

oMessage.Configuration.Fields.Update

oMessage.Subject = strSubject

oMessage.From = strSMTPFrom

oMessage.To = strSMTPTo

oMessage.TextBody = strTextBody

oMessage.AddAttachment strAttachment

oMessage.Send

topic Re: Email Alert and trigger in QlikView

Email Alert and trigger

Re: Email Alert and trigger