Send an Email from QlikView Application

[pradnyat]

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

[Anonymous]

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

[pradnyat]

Hi Laxmi,

Thanks for the help.

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

[Anonymous]

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

[pradnyat]

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.

[Anonymous]

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