Email Alert and trigger

[polisetti]

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.

[Anonymous]

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