So frankly I don’t know what DT is ( maybe Dark Templar ) but you could use read range as @postwick suggested and then use a send mail with body as HTML. In the HTML editor you can map the result of the read range ( the pivot table in your case ) as a HTML table and then send the email. The “(blank)” is a result of how you configured your pivot table
thanks a lot both @postwick and @dragos.suma. While I understood the concept, read range activity and html option are not available in my Studiox. I have tried it by both upgrading and downgrading Excel and Outlook packages from Manage Packages. I’m not sure if I am missing anything. Wondering what would be the other work around on this. Many thanks in advance
Hmmm … so in your case pretty much you have to use a Word document as an intermediary. What really puzzles me at the moment is that you should be able to see the 1.9.6 and later version of the Mail Package since we pushed it to the official feed.
Anyway … So the idea is that we faced this kind of feedback from our preview program back in the day and we came up with a workaround based on the idea that one ca use a Word document as an intermediary. You create the pivot table in a separate sheet and then you insert the entire sheet in a word document that you use later on as the body of the email .
As a follow-up question can you share a picture of your package manager settings ( note some of mine are blurred since I have access to the developer feeds and as you can see also working on unreleased versions of StudioX )
Didn’t want to highlight company name here. That’s why blackened it. Hope you don’t mind. Will try the solution with word activity you suggested and let you know. You have been a saviour all these while.
I tried this and it’s working but unfortunately this is not what I am looking for. The values inside the data table keep on changing along with the number of rows and column. Also the format of the data table that gets added to the email isn’t consistent. Once I am up for work, Will share my code along with the result.
Is it possible to capture a screenshot of the pivot area and add it on the second line of the email body? Any which ways, I am adding an attachment of the file. Appreciate your help