Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

How to connect to Gmail SMTP server over port 465 using SSL via QlikView desktop?

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support
Digital Support

How to connect to Gmail SMTP server over port 465 using SSL via QlikView desktop?

Last Update:

Sep 9, 2021 4:37:03 AM

Updated By:

Sonja_Bauernfeind

Created date:

Jul 6, 2012 1:01:08 AM


Attempting to connect to Gmail SMTP server over port 465 using SSL, but get a connection error.

pic1.jpg

Resolution:


The problem is that gmail-smtp port 465 requires SSL to work (http://support.google.com/mail/bin/answer.py?hl=en&answer=13287).
 

There is also another way to connect to GMail SMTP server, i.e. by using Macro (using a macro: http://community.qlikview.com/thread/25067) 
 
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
Labels (1)
Version history
Last update:
‎2021-09-09 04:37 AM
Updated by: