When I copy and paste onto an email outlook does not keep source formatting. I have been through so many options screens. How do I keep the source formatting intact?

Anonymous
2023-05-01T15:00:25+00:00

When I copy and paste onto an email outlook does not keep source formatting. I have been through so many options screens. How do I keep the source formatting intact? For instance I'll copy an excel file and paste it and it only come out as plain text . This wasn't an issue until I came into work today.

Microsoft 365 and Office | Excel | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2024-05-03T20:05:00+00:00

Hey everyone,

I may have a small workaround that I just discovered. I tested it out twice, but it seems to have worked for me so far, please let me know if you also have success or not. So, I typically copy my messages in color similar to the one displayed by Ornelaks in this thread. I decided (out of random curiosity) to use the copy and paste function within outlook to see if it would paste and keep the color formatting.

The first two tries of using copy and paste, I used the keyboard shortcut and the left click of the mouse. THEN, I used the the copy and paste icon located in the top left corner of outlook to paste it, and VIOLA! It kept all the color in the formatting. I hope this is helpful to you all (until it stops working again), but let me know if this is helpful!

Image

Was this answer helpful?

100+ people found this answer helpful.
0 comments

94 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2024-01-23T18:16:48+00:00

    I have the same issue and have gone through the recommended trouble-shooting steps to no avail, but I just discovered that, for me, it is a Google Sheets interface issue. When I copy/paste from Google Sheets, it is no longer retaining the format but if I pop the paste into Microsoft Excel then copy/paste into Outlook it is fine. Hope this might help someone!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2023-05-01T16:29:18+00:00

    Dear respected Josh Ryan_12345,

    Good day! Thank you for posting to Microsoft Community. We are happy to help you.

    I’m sorry you’re having a problem with "Keep Source Formatting" issue but based on your description we can work together to resolve it.

    For the situation you encountered, we deeply understand the inconvenience caused and apologize for it.

    As per your description, firstly may I know have you tried in Outlook > File > Option > Mail > Editor Options > Advanced > under Cut, copy and paste > Keep Source Formatting.

    Also, try toperform a clean boot in Windowsto determine whether a background program is interfering with Office program.

    If still can’t work, please try torepair an Office application to fix the problem.

    We appreciate your understanding that sometimes the initial suggestions may not resolve the problem very soon. However, we can work together to narrow down and resolve the situation. So, please kindly provide more information below to let us work further.

     1.What’s your Office version? Open Excel > File > Account > Production Information and share a screenshot of it.  (Please mask your private information.)

    1. Does the issue happens on all files or a specific one?
    2. Whether other applications also get the same problem? Such as PowerPoint or Word and etc.

    Appreciate your patience and understanding and thank you for your time and cooperation.

    Sincerely,

    Waqas Muhammad

    Was this answer helpful?

    10 people found this answer helpful.
    0 comments