topic Re: Microsoft Outlook Interface in QlikView

Microsoft Outlook Interface

Anonymous — Tue, 30 Sep 2014 20:44:03 GMT

Is there an interface in QlikView to Microsoft Outlook? Does the ability to email a QlikView chart through Outlook exist?

Ed Torasso

Re: Microsoft Outlook Interface

fkeuroglian — Tue, 30 Sep 2014 21:16:30 GMT

Do you want to send mail only=?

you can do this using macro

see this example:

SUB SendMail

Dim objEmail

Const cdoSendUsingPort = 2 ' Send the message using SMTP

Const cdoBasicAuth = 1 ' Clear-text authentication

Const cdoTimeout = 60 ' Timeout for SMTP in seconds

mailServer = "smtp.gmail.com"

SMTPport = 465

mailusername = "MyAccount@gmail.com"

mailpassword = "MyPassword"

mailto = "destination@company.com"

mailSubject = "Subject line"

mailBody = "This is the email body"

Set objEmail = CreateObject("CDO.Message")

Set objConf = objEmail.Configuration

Set objFlds = objConf.Fields

With objFlds

.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = cdoSendUsingPort

.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = mailServer

.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = SMTPport

.Item("http://schemas.microsoft.com/cdo/configuration/smtpusessl") = True

.Item("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = cdoTimeout

.Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = cdoBasicAuth

.Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = mailusername

.Item("http://schemas.microsoft.com/cdo/configuration/sendpassword") = mailpassword

.Update

End With

objEmail.To = mailto

objEmail.From = mailusername

objEmail.Subject = mailSubject

objEmail.TextBody = mailBody

objEmail.AddAttachment "C:\report.pdf"

objEmail.Send

Set objFlds = Nothing

Set objConf = Nothing

Set objEmail = Nothing

END SUB

Re: Microsoft Outlook Interface

MarcoWedel — Tue, 30 Sep 2014 21:28:45 GMT

Hi,

you can email QV reports from within QlikView Publisher / PDF report distribution without the need for an email client connection.

hope this helps

regards

Marco

Re: Microsoft Outlook Interface

MarcoWedel — Tue, 30 Sep 2014 21:30:32 GMT

maybe this helps also:

http://wiki.qvsource.com/MailBox-Connector-For-QlikView.ashx

regards

Marco

Re: Microsoft Outlook Interface

Anonymous — Tue, 30 Sep 2014 21:47:47 GMT

Thanks for the information Marco.

Re: Microsoft Outlook Interface

MarcoWedel — Tue, 30 Sep 2014 21:53:44 GMT

Hi,

maybe it helps, that there is also an MailBox Connector for QlikView available on QVsource.

regards

Marco