827711_en-US

liliconcom

JMP Report Send email as Excel or Email body

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).

 

Re: JMP Report Send email as Excel or Email body

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)

Re: JMP Report Send email as Excel or Email body

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?

Re: JMP Report Send email as Excel or Email body

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.

Re: JMP Report Send email as Excel or Email body

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