How to copy SSMS and paste into OneNote 365 while maintaining the formatting, as in the example below?

Question

When copying a query made in SSMS and pasting it into OneNote, the text becomes simple. If you paste it into the body of the Microsoft Outlook email, copy it again and paste it into OneNote, you will have the query formatting.

ctrl_v_onenote.png
image example: in the first part the query was copied from SSMS and pasted directly into OneNote

In the second part it was copied from SSMS, pasted into the body of the Microsoft Outlook email, copied again and pasted into OneNote

Answer 1

Hi @Ricardo Marcondes

OneNote does not support RTF format. It loses the text format when you paste RTF text.

You may copy the SSMS to Word first, then copy it from Word to OneNote as a workaround. The last part in following image is the SSMS copied from Word.

Or you can use 3rd-party add-in to Paste Rich Text.

Thanks for your understanding.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---