Sending Email Alert With QlikView

Fri, 12 Jun 2015 14:03:48 GMT

Hi Everyone,

So I'm working in a project with QlikView, and i want to send Email Alerts (gmail). I'm using a macro function and it works perfectly, the problem is that i can't call the macro in the alert event, can you help me please?

You'll find here the macro that i use, and the alert

Macro Code :

sub SendGMail() ' Object creation Set objMsg = CreateObject("CDO.Message") Set msgConf = CreateObject("CDO.Configuration") ' Server Configuration msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "smtp.gmail.com" msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25 msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1 msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = "MailFrom@gmail.com" msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "**********" msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpusessl") = 1 msgConf.Fields.Update ' Email objMsg.To = "MailTo@gmail.com" objMsg.From = "MailFrom@gmail.com" objMsg.Subject = "Test send with Gmail account" objMsg.HTMLBody = "HTML/Plain text message." objMsg.Sender = "Mr. Name" Set objMsg.Configuration = msgConf ' Send objMsg.Send ' Clear Set objMsg = nothing Set msgConf = nothing End sub

The Alert:

So Where can i call the macro in the alert?

Thank You,

topic Sending Email Alert With QlikView in QlikView

Sending Email Alert With QlikView