QV Email and Gmail SMTP

[#1]

Hi All,

Anyone know how to configure the mail settings for using gmail smtp? I configure the mail server settings in User Preference -> Mail. I tried all the authentication method, but it doesn't work (no SSL or TLS option in the authentication method). This is for sending an Alert email.

[Bill_Britt]

Hi,

You would do it here.

Bill

[#3]

But, this locale use for the alert error in tasks, no?

Regards.

[#4]

I put email in field Email in QVW, in LOAD IN LINE, example:

Data1:

LOAD * INLINE [

Region, Email

South, user1@email.com

East, user2@email.com

West, user3@email.com

];

If somebody help with this, use this and send email for what people you need.

Regards.

[Bill_Britt]

There is a word document I posted above that shows step by step.

Bill

[#6]

Correctly, but i don´t know where using the account emails.

I discovery, the account emails to send, is account where you put in load inline.

Regards.

[Bill_Britt]

Yes, or you can pull them in from a field in a table or Excel.

Bill

[#8]

Nice.

Thanks a lot!

[#9]

Hi Bill,

I saw your post and modified config file like below to send alert mail using gmail account.

<add key="UseSSLForSMTP" value="true"/>

Test mail was sent out successfully at QMC, but alert mail was not sent out when reload failed.

Below is the log for alert mail.

0486055 Information           Task Execute Duration=00:00:00.2502352

0486055 Information           Sending Alert mail

2841418 Warning  Failed to send mail to test@xxx.com

  Any suggestion?

[#10]

Hi Ayano,

Did you manage to resolve this issue? I am struggling with the same challenge - using Gmail, test email sends out ok, but when a task fails this doesn't happen and I can also see the "Failed to send mail to..." line in the task log.

Many thanks,

Aleksandar

[#11]

Hi,

Just in case someone else faces the same challenge. We resolved this issue. We also needed to change the Distribution Service configuration - file “QVDistributionService.exe.config” in C:\Program Files\QlikView\Distribution Service. The change was the same as for the Management Service config above.

The QlikView Server version in this case is 11.2 SR12.

Aleksandar