topic Re: Using JSL to send emails in Discussions

Using JSL to send emails

lou — Tue, 29 Oct 2019 14:22:30 GMT

I'm trying to use JSL to send emails as part of a data retrieval query. How do I embed a data table or Journal table into the body of my text message?

Thanks

Re: Using JSL to send emails

SDF1 — Tue, 29 Oct 2019 16:20:52 GMT

Hi @lou,

I did a search for Mail in the Scripting Index and found this:

Names Default To Here( 1 );
Mail( "test@example.com", "revelation", "JMP is great.", "$SAMPLE_DATA/Big Class.jmp" );

I tested it out with the Alarm Script example and it send me a message. I did not attach any JMP file, and not sure if it will embedd in the email body, but it will at least offer to add an attachment. Should solve your problem.

Hope this helps!,

Re: Using JSL to send emails

lou — Tue, 29 Oct 2019 17:20:02 GMT

Hi DS,

Thanks for your reply. Attaching is an alternative. Still looking for a way to add this to the main message, whether by table, journal or picture.

Lou

Re: Using JSL to send emails

SDF1 — Tue, 29 Oct 2019 19:26:25 GMT

Hi @lou,

This was a great challenge, and I think I figured it out. Should be only about three lines of code.

Names Default To Here( 1 );
dt = Data Table( "My Data Table" ); //this defines whichever data table you're dealing with
tb=dt<<Get As Report(); //this generates a data table report
Mail("myemail@address.com", "subject", "The data is " || Eval(tb<<Get Text)); //Using the Get text command generates a list, i.e. {"..."} which can be evaluated in the Mail command because it has quotes around it

I tested it on a data table of mine and it worked great. It even puts the text in a data table style/format. It is just text, but this should solve the original problem.

UPDATE: I went back and tested if you could add more text to the body and you can if you wrap the <<Get Text portion in an Eval() statement and concatenate with ||. So, I think this can get more advanced and "complicated" by concatenating several Eval() portions, depending on the complexity of the automated script.

Hope this helps!,

Re: Using JSL to send emails

lou — Tue, 29 Oct 2019 19:53:11 GMT

Hi DS,

Thank you very much!! This is what I needed! I appreciate your help.

Lou

Re: Using JSL to send emails

SDF1 — Tue, 29 Oct 2019 19:58:36 GMT

You're welcome. I also found out that if you include a \!n within quotations after your "opening sentence", you can have a carriage return before the data table is printed in the email.

Re: Using JSL to send emails

Stefan — Thu, 28 Jan 2021 15:46:29 GMT

Hi, how did you manage to add the carriage return, I've tried all options with \!n, but no success. Can you add an example please?

Cheers!

Re: Using JSL to send emails

SDF1 — Thu, 28 Jan 2021 16:16:56 GMT

Hi @Stefan ,

Using the "escape sequences", as they're called, can sometimes be a bit tricky. Sometimes they work as one would think they should, but other times they need to be invoked differently. It's kind of like :Column vs Column(dt, #), or As Column(). They all reference columns, but there are some cases where one is better than another.

Anyway, you were wanting a specific example for the carriage return, here is one that works with a built in data table in JMP.

Names Default To Here( 1 );
Open( "$SAMPLE_DATA/Big Class.jmp" );
dt = Data Table( "Big Class" );
tb=dt<<Get As Report();
Mail("myemail@address.com", "dt names", "The data is "||"\!n"||Eval(tb<<Get Text));

You don't have to have the extra concatenate || in there between "The data is " and !\n. You can instead write it as "The data is !\n" || Eval() and it'll work just the same. But, however you implement it, the !\n must be in quotations: "\!n" for it to be read correctly.

One note that might be the reason you're having problems is the host operating system. If you're working in OS vs Windows, then the carriage return is different: CR vs CR LF, respectively. If you're on a Mac, the "\!n" won't work. Instead, you should use "\!N" with a capital N. When you use that, it insert a line break appropriate for the host operating system.

Hope this helps!,

Re: Using JSL to send emails

Stefan — Thu, 28 Jan 2021 16:39:27 GMT

@SDF1 thanks for the quick reply, tried the few options you are recommending, no joy still. I am running on Windows, JMP 15.2.1

This is the excerpt from the email body...

The data is name age sex height weight...

Re: Using JSL to send emails

SDF1 — Thu, 28 Jan 2021 16:49:23 GMT

Hi @Stefan ,

That is really strange. I'm running JMP Pro 15.2.1 on W10 64-bit. This functionality is certainly not Pro dependent, so I can't imagine that's the case. When I run that code for the Big Class, I get this email out:

Did you copy/paste the code exactly, with only changing the email address? If the code was changed other than the email address, this could impact the formatting in the email. Do you have a screen shot of the code and email you receive from JMP?

Re: Using JSL to send emails

Stefan — Fri, 29 Jan 2021 09:18:28 GMT

Hi, this is the print screen...I think the issue might be the fact that I am not using Outlook as the email client, I am using Mailbird. Will try to configure Outlook and update

Re: Using JSL to send emails

Stefan — Fri, 29 Jan 2021 12:54:20 GMT

Hi, it was indeed the email client. I uninstalled Mailbird and used Outlook and worked fine...

Thank you for your help!

Re: Using JSL to send emails

SDF1 — Fri, 29 Jan 2021 13:20:17 GMT

Glad to hear that you figured out the mail client issue. Odd that it should be so dependent on that, but so are carriage returns. Glad it's now working for you.

DS

Re: Using JSL to send emails

lalala — Wed, 17 Feb 2021 08:58:41 GMT

Hi. is there a way the alignment per column be fixed? or if i could change the default font style used in this HTML email, cause it seems that the column is not align due to the letters in the default font style(arial) used takes different space per letter(like "I" has different space than "M"). so is there a way to change the font style or any other suggestion how to fix the alignment per column. thank you.

Re: Using JSL to send emails

SDF1 — Wed, 17 Feb 2021 14:26:24 GMT

Hi @lalala ,

Not sure if there is a way to do it with the commands that were listed previously in this thread. The text is just tab-delimited and you can edit it in the email. I am not aware of any commands to modify this when sending the table as text

However, there is a possible workaround that might suit your needs. You have to get the data table report as a picture, save it, and then send it as an attachment. It will look like the data table format in JMP report windows.

Names Default To Here( 1 );
Open( "$SAMPLE_DATA/Big Class.jmp" );
dt = Data Table( "Big Class" );
path="your path\"; //be sure to have the last backslash included in this.
tb=dt<<Get As Report();
tb<<Get Picture();
tb<<Save Picture(path||"pic.png", "png");
Mail("my.email@email.com", "dt names", "The data is \!n", path||"pic.png");

You can of course save the picture in different formats than png.

The attachment will look like this:

Not ideal, but the data will be formatted and aligned as desired. It won't be editable or copy/pastable like the text email version. Perhaps you can put in a request to JMP to have them provide more options for the Get Text() command so it can provide more complex formatting options?

Hope this helps!,

Re: Using JSL to send emails

lalala — Thu, 18 Feb 2021 01:52:41 GMT

hi. Thank you for your quick response.

But, I would like to ask again, could there be a possibility that I could attach the photo to the mail's body? Thank you in advance.

Re: Using JSL to send emails

SDF1 — Thu, 18 Feb 2021 13:48:01 GMT

Not that I'm aware of.

Re: Using JSL to send emails

dadawasozo — Sat, 03 Jun 2023 12:15:22 GMT

Hi DS,

Is it possible to to send picture in the email body (not attachment) and at the same time attach a table? The Eval () and get text not working for picture

Re: Using JSL to send emails

SDF1 — Tue, 06 Jun 2023 18:00:20 GMT

Hi @dadawasozo ,

Not that I'm aware of, I believe you can only add it as an attachment, not within the body of the email. I think it can only handle text in the email.