Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Entire sheet as an image and email in Outlook

Hi,

I have a macro exporting the entire sheet into JPG image and embed the image in the outlook message box.(not an attachment)

The macro works well only for the current screen of the sheet but not the pagedown/pageup objects.That is, only the objects that are seen on the screen are captured as image,but not the other objects (when we scroll the sheet the objects above/below the screen are not getting copied in the image.

The macro I have is

 

     SUB openMail

     'Export entire Sheet
     Set Sheet = ActiveDocument.ActiveSheet
     Sheet.ExportBitmapToFile "D:\\TestAttachImage.jpg"
     'MsgBox "Test Image Exported"

     Set vOutlook = CreateObject("Outlook.Application")
     Set vMessage = vOutlook.CreateItem(olMailItem)

     vMessage.To = " "
     vMessage.Subject = "QlikView Sheet Testing"

 

     vMessage.HTMLBODY = "<HTML><BODY><img align=baseline border=0 hspace=100 src=""D:\\TestAttachImage.jpg""</BODY></HTML>"

     vMessage.Display
     'MsgBox "Image embedded"

      END SUB

Is there any way I can copy entire sheet objects in a single JPG image file?(the objects down the scroll bar(pagedown))

Community Browser