I am a new Mac user, struggling to copy from an email in Mail into Numbers.

I get an email for a web order and need to copy it into a Numbers spreadsheet so it then populates forms on other tabs. But when I paste the email from Mail into Numbers it only pastes the first part of the email. It doesn't paste the rest. The only way I can do it is line by line, which takes ages!

It must be something to do with the format of the email in Mail or the way Numbers allows this to be pasting into it.

This exact operation has always worked fine for me with Outlook and Excel - I don't want to have to go back to Microsoft!

Does anyone have any advice?