macro send Email with office 365

Fri, 02 Apr 2021 08:01:40 GMT

Hi,

I can't send a mail with office 365, i have allready reed all de blogs.

with an other un SMTP server it's ok.

this is my script :

' Server Configuration
msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "smtp.office365.com"
msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpusessl") = True
msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/UseSSLForSMTP") = True

msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 0
msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = "utilisateur@domaine'
msgConf.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "password"

msgConf.Fields.Update

Please help me, thank

Re: macro send Email with office 365

stevedark — Tue, 27 Jun 2017 14:03:19 GMT

Hi Christophe,

There are issues with sending email with Office365 (and GMail) because QlikView doesn't properly support the security protocols they use.

I'm not sure if the same issues will be affecting using Qlik Web Connectors when sending.

Here is a link to a post which describes how a tool called STunnel can be used to act as a proxy, effectively allowing you to send to a local SMTP host with no SSL security which is then relayed onto another host on a different port:

Mail server settings

Be aware that if you have something already on port 25 on your local machine you may need to use a different port.

Hope that helps.

Steve

topic macro send Email with office 365 in Connectivity & Data Prep

macro send Email with office 365

Re: macro send Email with office 365