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.
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 = "email@example.com" objMsg.Display End sub
I have never used it before. But found it useful for you.