Sending reports(excel) by email

Wed, 22 Oct 2014 09:14:20 GMT

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 !

Re: Sending reports(excel) by email

Anonymous — Thu, 23 Oct 2014 19:21:38 GMT

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.

Re: Sending reports(excel) by email

Mon, 23 May 2016 13:24:22 GMT

Hi DD

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

Thanks In Advance

Ramarajan M

Re: Sending reports(excel) by email

oknotsen — Mon, 23 May 2016 13:29:21 GMT

Please start new questions in a new topic.

Topic locked.

topic Sending reports(excel) by email in QlikView

Sending reports(excel) by email

Re: Sending reports(excel) by email

Re: Sending reports(excel) by email

Re: Sending reports(excel) by email