nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JMP Report Send email as Excel or Email body

HyeWonJung

Hello,
Using the Append function, I combined three data tables into one report. Is it possible to send this report via email in Excel format or include it in the email body? I was able to implement it in PPT or PDF, but the customer asked if it could also be done in Excel format or embedded in the email body. attached is the JSL code I tested using sample data (Big Class).

raw data table_multiple reports_pdf_revised.jsl

Accepted answers

Jed_Campbell

To include the report directly in the body, you might be able to use what on this link to create an HTML of the report, then have that HTML as the body of the message.

All comments

Jed_Campbell

I believe the email() command allows attaching a list of filenames, so you could save the data tables as .xlsx files, then attach them as well. Something like this should* work:

names default to here (1);
dt = open ("$SAMPLE_DATA/Big Class.jmp");
dist = dt << run script ("Distribution");
dist << save presentation ("$DESKTOP/dist.pptx");
dt << save as ("$DESKTOP/Big Class.xlsx");
mail ("jed.campbell@jmp.com", "test", "message", {"$DESKTOP/dist.pptx","$DESKTOP/Big Class.xlsx"});<BR /><BR />*(I haven't been able to test it because I broke something on my computer using regedit.exe to try to bypass the dialogue that requires waiting and clicking "allow" for each email)

HyeWonJung

Thank you for your response!

However, my customer's question was not about the data table but whether it is possible to export a report to Excel or include it directly in the email body. Is this achievable?

Jed_Campbell

To include the report directly in the body, you might be able to use what on this link to create an HTML of the report, then have that HTML as the body of the message.

HyeWonJung

@Jed_Campbell Thank you. refer to above link and using powershell, i can send HTML as email body.