topic Failure in sending mail through Qlikview in QlikView

Failure in sending mail through Qlikview

eliran — Tue, 26 Apr 2011 09:04:56 GMT

Hi all,

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.

function sendme()

set objMessage = CreateObject("CDO.Message")

objMessage.Subject = "Subject"

objMessage.From = "eliran@gmail.com"

objMessage.To="xxxx@gmail.com"

objMessage.TextBody="testing Body"

objMessage.Configuration.Fields.Item _

("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2

objMessage.Configuration.Fields.Item _

("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "smtp.gmail.com"

objMessage.Configuration.Fields.Item _

("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 587

objMessage.Configuration.Fields.Update

objMessage.Send

end function

Thanks for any help,

Eliran.

Re: Failure in sending mail through Qlikview

Miguel_Angel_Baeyens — Tue, 26 Apr 2011 09:25:37 GMT

Hello Eliran,

Gmail needs to specify SSL, give a try to the code in this post.

Hope this helps.

Failure in sending mail through Qlikview

eliran — Tue, 26 Apr 2011 09:38:04 GMT

Hi Miguel,

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?

Regards,

Eliran.

Failure in sending mail through Qlikview

Miguel_Angel_Baeyens — Tue, 26 Apr 2011 09:43:24 GMT

Hi,

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.

Failure in sending mail through Qlikview

eliran — Tue, 26 Apr 2011 10:35:10 GMT

Thanks Miguel,

My firewall blocked it.

Regards,

Eliran.

Failure in sending mail through Qlikview

Thu, 27 Oct 2011 09:59:35 GMT

Hi Miguel, can you re-post your code? I can't open the link.

Thank you very much.

Roby

Failure in sending mail through Qlikview

Miguel_Angel_Baeyens — Fri, 28 Oct 2011 20:32:41 GMT

Hi Roby,

Check this post. I'll change the post above that points to the old QlikCommunity files.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Failure in sending mail through Qlikview

Wed, 02 Nov 2011 08:16:19 GMT

Thank you very much !

Roby