Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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 !

3 Replies
Anonymous
Not applicable
Author

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
Author

Hi DD

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

Thanks In Advance

Ramarajan M

oknotsen
Master III
Master III

Please start new questions in a new topic.

Topic locked.

May you live in interesting times!