topic Re: MAIL SMTP SETTINGS Personal Edition in QlikView

MAIL SMTP SETTINGS Personal Edition

Fri, 16 May 2014 15:47:43 GMT

Hello All,

I am doing a POC for a client using a personal edition for which I need to create EMAIl ALERTS based on a certain condition. I was trying to configure email alert setting under user preference-> Mail Settings but the settings did not work, I don't have the client network access yet, could this even be done in a personal edition and on home network like using Gmaili SMTP settings, which I tried so many times and TEST always gave an error. Could someone please help me answer this ?

Re: MAIL SMTP SETTINGS Personal Edition

stabben23 — Fri, 16 May 2014 18:55:52 GMT

Can you post a sampled file?

Re: Re: MAIL SMTP SETTINGS Personal Edition

Fri, 16 May 2014 19:00:04 GMT

Hello Staffan,

Say I want to do the mail settings in this file only where an alert would be triggered when id=1, how could I do that?

I have a personal edition of qlikview , I don't know if it is a constraing and I am on my home network.

Thanks and Regards,

Ronak jain

Re: MAIL SMTP SETTINGS Personal Edition

Joseph_Musekura — Fri, 16 May 2014 19:24:28 GMT

Hi,

Here is an example of settings under user preference-> Mail Settings

What are you missing here?

Re: MAIL SMTP SETTINGS Personal Edition

Fri, 16 May 2014 20:04:35 GMT

Can I use any other SMTP server besides My Company's. I tried smtp.gmail.com and port #465 but it was giving me a lot of errors

Re: Re: MAIL SMTP SETTINGS Personal Edition

Joseph_Musekura — Sat, 17 May 2014 21:52:29 GMT

Hi,

You can use smpt.gmail.com and port 465 as this require SSL.

see http://support.google.com/mail/bin/answer.py?hl=en&answer=13287

In the previous attached settings under user preference-> Mail Settings, SSL is not listed in Authentication mode.

If you want to use Gmail, a possible solution is macro

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") = 465 msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1 msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = "user@gmail.com" msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "password" msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpusessl") = 1 msgConf.Fields.Update ' Email objMsg.To = "user@gmail.com" objMsg.From = "fromuser@domain.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

Note : Please check

http://community.qlik.com/message/264170#264170