Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
Not applicable

MAIL SMTP SETTINGS Personal Edition

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 ?

5 Replies
Highlighted
Honored Contributor

Re: MAIL SMTP SETTINGS Personal Edition

Can you post a sampled file?

Highlighted
Not applicable

Re: Re: MAIL SMTP SETTINGS Personal Edition

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

Highlighted
Support
Support

Re: MAIL SMTP SETTINGS Personal Edition

Hi,

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

mailAlertSetings.png

What are you missing here?

Highlighted
Not applicable

Re: MAIL SMTP SETTINGS Personal Edition

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

Highlighted
Support
Support

Re: Re: MAIL SMTP SETTINGS Personal Edition

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