2 Replies Latest reply: Feb 1, 2013 10:03 AM by Badunit
HelMC Level 1 Level 1 (0 points)

I have to copy and paste a press log table into a weekly email.

Sometimes it copies into the body of the email and retains the formating of the table, such as below:


Screen shot 2013-02-01 at 14.38.44.png


Other times it seems to truncate some of the colums so that the text is squashed into long tall columns...I can't work out why this happens sometimes, and not other times, as it looks very awkward to read this way. See example below.


Screen shot 2013-02-01 at 14.37.47.png


Any suggestions?

  • 1. Re: Copying table into email
    Wayne Contello Level 6 Level 6 (13,615 points)

    Here are a couple ways:

    1)  copy the table then open the Application Preview, then create a new document using the men item "File > New from Clipboard...",


    Then use the rectangular selection tool to select the table , copy, then return to the email, paste.



    2) make the table fit onto a printable page (using the Print View in Numbers), then print to a PDF and mail the PDF.... you can even use the email PDF directly from the print dialog:

    Screen Shot 2013-02-01 at 10.52.52 AM.png

  • 2. Re: Copying table into email
    Badunit Level 6 Level 6 (10,815 points)

    What I see in the screenshot of the problematic email is a link that has a long "word" in it. It contains a bunch of words separated by underscores and you will notice the link only linebreaks when it gets to a dash, finally ending that long "word". In my testing, I got the same result when I used a link like that but not for other links. This makes the column extra wide and the result is the other columns get less wide (unless you increase the viewing width of your email which will let the other columns expand back out again).


    I don't see a way to prevent this when doing a copy/paste of the table from Numbers. My suggestion is similar to one of Wayne's except this method and Wayne's kill the clickable links:


    1. Select the table in the Numbers sidebar
    2. Copy
    3. Open the Preview App
    4. New from Clipboard
    5. Drag the image from Preview's sidebar and drop it in your email


    You can also email the entire document as a PDF using Share/Email/PDF. If your document consists of only the one table this might work for you. It will preserve the clickable links.


    I'm guessing this is a Mail problem, not a Numbers problem. It doesn't seem to handle the paste from the clipboard as we would expect it to. When you do the Numbers-to-Preview-to-Mail route, you'll notice it actually pastes a PDF image of the table, not a table "object" (or whatever you might call it) like it does straight from Numbers.