@Pierre73
From what I could gather from your text, you want to create an office script that converts a CSV file to an Excel spreadsheet, and then use that script in Power Automate to send emails.
Here's an example of how you can write an Office script to convert a CSV file to an Excel spreadsheet:
function main(workbook: ExcelScript.Workbook) {
// Get the current worksheet
let sheet = workbook.getActiveWorksheet();
// Get the data from the CSV file
let csvData = `Sales Name,First Name,Email
John Dow,John,email address removed for privacy reasons
Roger Stone,Roger,email address removed for privacy reasons
Claire Dupont,Claire,email address removed for privacy reasons`;
// Split the CSV data into rows
let rows = csvData.split("\n");
// Loop through each row
for (let i = 0; i < rows.length; i++) {
// Split the row into columns
let columns = rows[i].split(",");
// Loop through each column
for (let j = 0; j < columns.length; j++) {
// Set the value of the cell
sheet.getCell(i, j).setValue(columns[j]);
}
}
// Create a table from the data
let table = sheet.addTable(sheet.getUsedRange().getAddress(), true);
}
*Script from Internet.
This script gets the data from a CSV file and splits it into rows.
It then loops through each row and splits it into columns.
The script sets the value of each cell in the worksheet based on the data from the CSV file.
Finally, it creates a table from the data in the worksheet.
You can then use this script in Power Automate to convert your CSV file into an Excel table and send emails based on the data in the table.
As for making the emails clickable, you can format the cells containing email addresses as hyperlinks. This will make them clickable and allow users to easily send emails by clicking on the email addresses.
I hope this helps!
