Sending Email Alert With QlikView

[#1]

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,