I know it's been discussed few times but I can't figure out why I fail to send mail through Qlikview.
I stripped the code down to just necessary lines and the macro editor jumps when the send command is executed, thus failing to send the mail.
set objMessage = CreateObject("CDO.Message")
objMessage.Subject = "Subject"
objMessage.From = "email@example.com"
("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "smtp.gmail.com"
("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 587
Thanks for any help,
I'm afraid the same thing happens when I try your code, the code ObMsg.Send is highlighted and the macro is failing.
Am I missing something else?
Does your computer have some firewall, antivirus software that is avoiding qv.exe from sending emails? The code itself works using your own username and password. If it doesn't I'd think of:
1.- Macro permissions: Go to the macro editor, and Allow System Access
2.- External software preventing QlikView sending emails.
Hope that helps.