Copy data from Excel and paste to Outlook pop out this error "Tables will be lost"

Question

Hi Microsoft (Microsoft 365 Version2311 Build 17029.20668) ,

Normally when I copy the data from excel and paste to outlook it will paste exactly the same table with data, but today it suddenly show "Tables will be lost", and when I click the 'Continue' button the data will paste without the table and only left the text.

May I know why?

Answer 1

Hello,

Thank you for posting here in Microsoft Community.

As per checking on the screenshot you have provided, you are most likely replying to a plain text email which does not support  bold or italic text, colored fonts, or other text formatting and photos. This is why you are getting this prompt, what I suggest is you can switch the formatting to HTML. The default text formatting may depend on what email you are replying, in case it's not default as HTML you can always feel free to change it.

Here's how:

1. In the reply box that is currently open, click on Format Text if you happen to not see it, you may need click the Pop Out first.
2. From there change the Format to HTML. Then try pasting the table again.

I hope this helps!

Best regards,

Arquel C.

Microsoft Moderator

Answer 2

Hello,   We haven't heard from you, so we assume that your issue has already been addressed. We will not be monitoring this thread moving forward so, if you need further assistance, please create a new thread to discuss these concerns by clicking this link: Create a new question (microsoft.com)Thank you for understanding.Regards,Arquel C.Microsoft Moderator