Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Sending reports(excel) by email

Hi!

It works correctly , sends the mail without problems with this code:

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

I added this to send an attachment :

objMsg.AddAttachment "C:\qliksense\tabla.xls"

And it works too but now I need to "type"/"insert" object(excel) into mail's body  QlikView table that I want, not attachment.

Someone please help me ?? Thank you !

Tags (3)
3 Replies
stevenrtaylor
Not applicable

Re: Sending reports(excel) by email

Can whatever process that generates C:\qliksense\tabla.xls create the file c:\qliksense\tabla.mhtml instead and include that file in the message body?

Not too familiar with this, but is fairly similar to other reporting technologies I've used.

Not applicable

Re: Sending reports(excel) by email

Hi DD

Could you please help me how to send a mail in QLIKSENSE .

Thanks In Advance

Ramarajan M

oknotsen
Not applicable

Re: Sending reports(excel) by email

Please start new questions in a new topic.

Topic locked.

May you live in interesting times!