Copying and pasting data from the data table to email

shampton82

Hey everyone,

When trying to copy data from a data table and pasting into an email, JMP will not respect the columns on pasting vs if you copy and paste from excel it will respect the columns.  So my work around is to save the data table to an excel table, copy and paste it into the email, then close the excel file.  Beyond annoying.  I'm hoping that I am missing something obvious as a better way to perform this task.

Here is an example of excel (top) vs JMP(bottom) when pasting data from Big Class into an email

The more that the values in the columns are of different lengths, the worse this gets.

 

Thanks for any ideas!

 

Steve

Ben_BarrIngh

Hi @shampton82 ,

 

I think this might be caused by  the changes to Outlook, it used to be you could go on any office application (like you still can with Word) and go "Paste Special> Unformatted Unicode Text" and it would put out the table formatted as you would like - from the looks of it the reason Excel works is because Microsoft already knows it has come from excel 

 

"Text has its own formatting — such as typeface, color, and font size. When you copy text into a Microsoft 365 app, the app automatically reformats that text to match the text of the destination. However, you can use Paste Special to maintain the original formatting or to paste it as a picture or a link"

 

Thanks,

Ben