Generate an excel(.xlsx) using email scripts

[SNow35]

Hi All,

We have requirement to generate an excel(.xlsx) file using email script, we were able to get the .csv but need it in .xlsx. Please help us on how to achieve this.

@Ankur Bawiskar  Please help here if you can.

Thanks in advance.

[Sai Kumar B]

@SNow35 

I don't think you can generate .xlsx files using a script unless you built your script utility. I would suggest 

1.) Create a report on your table

2.) Create a "Scheduled Email report" and associate the newly created report and the Users/Groups to whom you want to send the report

3.) Choose report type as .xlsx

4.) Set the schedule time Daily/weekly/monthly along with time

5.) You can also call Email scripts in Scheduled email report body

[SNow35]

We have few issues taking this approach.

1. As out instance is domain separated the excel is showing in global domain.

2. We have a script include which we are using in reports, which doesnot give any records. 

any suggestions around this?

[Sai Kumar B]

@SNow35 What the Script Include does?

[SNow35]

It is grouping the records based on the suppliers. 

Like our use case is to send the email of the records for each supplier which needs to be handled using script.