Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

manisha_uit
Contributor

Scheduling and sending Qlikview document in message body

Hi,

I have a requirement of scheduling a qlikview document and sending it as email. But the report should come in the message body rather than an attachment.

How can I achieve this.

if anyone has any idea please share

Thanks

Manisha

1 Reply
kamalqlik
Valued Contributor

Scheduling and sending Qlikview document in message body

Hi,

Manisha...you have to write the macro for this.

just write this in the Macro...

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

regards

Kamal