Copy-Pasting a table to Word or Outlook Email to preserve Formatting

[#1]

Hello!

I want to email a QV Straight or Pivot Table to a colleague who does not have access to the app.

When I copy the Full Table and paste to an email it pastes in an ugly default format: Times New Roman font, double line cell borders.

This behaviour happens when I paste into a Word document as well.

Any idea how I can copy over the formatting on the table in Qlikview, or otherwise change this default format?

Thanks

Mike

[Anil_Babu_Samineni]

You can use this macro

SUB Font

set obj = ActiveDocument.GetSheetObject("CH01")

set fnt = obj.GetFrameDef.Font

fnt.PointSize1000 = fnt.PointSize1000 + 1000

fnt.FontName = "Calibri"

fnt.Bold = false

fnt.Italic = false

fnt.Underline = true

obj.SetFont fnt

END SUB