Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Send an Email from QlikView Application

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

5 Replies
Highlighted
Creator II
Creator II

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

Highlighted
Creator
Creator

Hi Laxmi,

Thanks for the help.

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

Highlighted
Creator II
Creator II


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

Highlighted
Creator
Creator

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.

Creator II
Creator II

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