Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

E-mail activex cdo message

Hi,

tried to send an e-mail via Qlikview. Hitting the send button open macro editor at line "objMessage.Send". The errormessage is

"The server rejected the sender address. The server response was: 550 5.7.0 Need to authenticate via SMTP-AUTH-Login {mp068}"

Tried with my gmx account.With AOL I get: "The server rejected the sender address. The server response was: 556 CLIENT AUTHENTICATION REQUIRED. USE ESMTP EHLO AND AUTH."

tried this with an asp page on local webserver and it works.

Code (from Eugene)

Public Function SendMail (SendTo)


Set objMessage = CreateObject("CDO.Message")
objMessage.Subject = Subject
objMessage.From = From
objMessage.To = SendTo
objMessage.CC = SendCC
objMessage.BCC = SendBCC
objMessage.TextBody = Body
'msgbox Attachment
if( not "" = Attachment) then
objMessage.AddAttachment Attachment
end if

objMessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2

objMessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "smtp.gmx.net"


objMessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/sendusername ") ="user"

objMessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/sendpassword ") ="password"

objMessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = cdoBasic

objMessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25

objMessage.Configuration.Fields.Update

objMessage.Send
End Function

I guess I forgot something. Anyone an idea?

Thanks

0 Replies