topic Send an Email from QlikView Application in QlikView

Send an Email from QlikView Application

pradnyat — Tue, 16 Sep 2014 06:57:03 GMT

Hi All,

We have one requirement like on sheet there will be one Email button.

When user clicks on that button it should redirect user to the enter some email body and the email address and when user clicks on OK, it should send the mail to the respective recipients with the current sheet screen shot as attachment.

Can anybody help us with how we can implement it in QlikView.

Any help would be appreciated.

Thanks in Advance...!

Regards,

Pradnya

Re: Send an Email from QlikView Application

Anonymous — Tue, 16 Sep 2014 09:45:14 GMT

Hi Pradnya,

PFA Qlikview report with a Button which when clicked composes a mail. And you can enter the body of the mail and send it.

Hope this helps you!

Laxmi

Re: Send an Email from QlikView Application

pradnyat — Tue, 16 Sep 2014 10:25:43 GMT

Hi Laxmi,

Thanks for the help.

Can I attach the sheet image or screenshot as an attachment to the email ?

Re: Send an Email from QlikView Application

Anonymous — Tue, 16 Sep 2014 12:47:14 GMT

Hi Pradnya,

If you need you attachment to be attached to the mail automatically then you need to use macros.

Sub Send()
Set objOL = CreateObject("Outlook.Application")
Set objMsg = objOL.CreateItem(olMailItem)
objMsg.Attachments.Add "c:\samplefile1.txt"
objMsg.Attachments.Add "c:\samplefile2.txt"
objMsg.subject = "Subject line"
objMsg.body = "Your files are ready to send."
objMsg.to = "test@domain.com"
objMsg.Display
End sub

I have never used it before. But found it useful for you.

Laxmi

Re: Send an Email from QlikView Application

pradnyat — Tue, 16 Sep 2014 12:53:24 GMT

Thanks a lot Laxmi.

Is there any alternative for macro. As we need to implement this for ipad and macros might not work for some browsers as well as it can cause a performance issues also.

Re: Send an Email from QlikView Application

Anonymous — Wed, 17 Sep 2014 09:59:53 GMT

Hi Pradnya,

As far as I understood or explored Macros are the only solutions for the attachment to email issue.

I am still exploring on it. If I find any solution, will let you know.

In your case, if you are not willing to use macros then you have only one solution. And that is attaching the attachment while composing the mail.

Enable the copy image to clipboard option for the object you want to attach. And while composing the mail just paste that image.

Good Luck.

Laxmi