# Loosing color and formatting when copying queries from TOAD to Word or Outlook

**URL:** <https://forums.toadworld.com/t/loosing-color-and-formatting-when-copying-queries-from-toad-to-word-or-outlook/38781>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [December 8, 2016, 4:51am UTC](https://forums.toadworld.com/t/loosing-color-and-formatting-when-copying-queries-from-toad-to-word-or-outlook/38781 "2016-12-08T04:51:30Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![geir.k.edland](https://avatars.discourse-cdn.com/v4/letter/g/f475e1/32.png) [@geir.k.edland](https://forums.toadworld.com/u/geir.k.edland)\
**Post date:** [December 8, 2016, 4:51am UTC](https://forums.toadworld.com/t/loosing-color-and-formatting-when-copying-queries-from-toad-to-word-or-outlook/38781/1 "2016-12-08T04:51:30Z")

</div>

Hi

This may be TOAD-related - but might as well be something else:

I recently had to set up a new laptop with TOAD - this time on Windows 10.

Now I realise I can not copy a formatted (and colored) SQL-statement from the TOAD editor into a word-document or an email (set up with HTML format). When pasting it from clipboard - it just comes out as plain text.

I have a collegue with the same setup Windows 10 and Toad 12.9 64 bit. She does not have this problem. And I did not have it on my previous laptop running Windows 8.1 Update and TOAD 12.9

I have now upgraded to TOAD 12.10 - but it did not help.

When copying from other sources (like a web-page) - I do not loose color or format.

I did find some very old discussions on the net - on the same issue - but from back in 2005-2007. They said it had something to do with Skype - but that is not my case.

Anyone got i solution? It is very annoying!

Geir K. Edland

---

<div class="post-metadata">

**Author:** ![GTDG](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gtdg/32/140_2.png) [@GTDG](https://forums.toadworld.com/u/GTDG)\
**Post date:** [December 8, 2016, 4:56am UTC](https://forums.toadworld.com/t/loosing-color-and-formatting-when-copying-queries-from-toad-to-word-or-outlook/38781/2 "2016-12-08T04:56:09Z")

</div>

Geir,

Try Options -\> Editor -\> Behavior -\> Copy text in rich text format.

---

<div class="post-metadata">

**Author:** ![david.fimble](https://avatars.discourse-cdn.com/v4/letter/d/f475e1/32.png) [@david.fimble](https://forums.toadworld.com/u/david.fimble)\
**Post date:** [December 8, 2016, 4:59am UTC](https://forums.toadworld.com/t/loosing-color-and-formatting-when-copying-queries-from-toad-to-word-or-outlook/38781/3 "2016-12-08T04:59:45Z")

</div>

If you will go to “Options-\>Editor-\>Behavior” and check “Copy text in rich text format”… that should fix your issue.

David

**From:** geir.k.edland [[mailto:bounce-geirkedland@toadworld.com](mailto:bounce-geirkedland@toadworld.com)]

**Sent:** Thursday, December 08, 2016 6:54 AM

**To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com)

**Subject:** [Toad for Oracle - Discussion Forum] Loosing color and formatting when copying queries from TOAD to Word or Outlook

# EXTERNAL EMAIL

**[Loosing color and formatting when copying queries from TOAD to Word or Outlook](http://www.toadworld.com/products/toad-for-oracle/f/10/t/31855)**

Thread created by geir.k.edland

Hi

This may be TOAD-related - but might as well be something else:

I recently had to set up a new laptop with TOAD - this time on Windows 10.

Now I realise I can not copy a formatted (and colored) SQL-statement from the TOAD editor into a word-document or an email (set up with HTML format). When pasting it from clipboard - it just comes out as plain text.

I have a collegue with the same setup Windows 10 and Toad 12.9 64 bit. She does not have this problem. And I did not have it on my previous laptop running Windows 8.1 Update and TOAD 12.9

I have now upgraded to TOAD 12.10 - but it did not help.

When copying from other sources (like a web-page) - I do not loose color or format.

I did find some very old discussions on the net - on the same issue - but from back in 2005-2007. They said it had something to do with Skype - but that is not my case.

Anyone got i solution? It is very annoying!

Geir K. Edland

To reply, please reply-all to this email.

[Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/31855?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle Forum](http://www.toadworld.com/products/toad-for-oracle/f/10?subscribe=false) notifications altogether.

Toad for Oracle - Discussion Forum

[Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/t/31855?AbuseContentId=440bc29f-a0ed-44f7-95bd-087701da95bc&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true)  
this post as spam/abuse.

* * *

\*\*\*\*\* This email is from an external sender outside of the CenterPoint Energy network. Be cautious about clicking links or opening attachments from unknown sources. \*\*\*\*\*

* * *

---

<div class="post-metadata">

**Author:** ![geir.k.edland](https://avatars.discourse-cdn.com/v4/letter/g/f475e1/32.png) [@geir.k.edland](https://forums.toadworld.com/u/geir.k.edland)\
**Post date:** [December 8, 2016, 7:02am UTC](https://forums.toadworld.com/t/loosing-color-and-formatting-when-copying-queries-from-toad-to-word-or-outlook/38781/4 "2016-12-08T07:02:56Z")

</div>

Thanks! I thought I had checked all options - but obviously not! Good til be “back on track”!

---

<div class="post-metadata">

**Author:** ![tom.wickerath](https://avatars.discourse-cdn.com/v4/letter/t/bb73d2/32.png) [@tom.wickerath](https://forums.toadworld.com/u/tom.wickerath)\
**Post date:** [March 24, 2017, 8:23pm UTC](https://forums.toadworld.com/t/loosing-color-and-formatting-when-copying-queries-from-toad-to-word-or-outlook/38781/5 "2017-03-24T20:23:44Z")

</div>

I had the option "Copy text in rich text format" checked, but was still plagued by not getting the rich text copied into either a new Outlook email message or a new Word document. Apparently in Office, I had previously set a default paste option as Text Only. So, the answer is to click on the little Paste Options button in the target document (e.g. e-mail or Word document) and make sure to select "Keep Source Formatting".

 ![TOADCopy.png](https://global.discourse-cdn.com/quest/original/2X/d/d73eb308bd03eb1b2871485ed096b70158953633.png)

---

<div class="post-metadata">

**Author:** ![vishal.shah](https://avatars.discourse-cdn.com/v4/letter/v/ad7895/32.png) [@vishal.shah](https://forums.toadworld.com/u/vishal.shah)\
**Post date:** [June 9, 2021, 8:28pm UTC](https://forums.toadworld.com/t/loosing-color-and-formatting-when-copying-queries-from-toad-to-word-or-outlook/38781/7 "2021-06-09T20:28:58Z")

</div>

In TOAD for Oracle 12.11,

Go to Menu...  
View --\> Toad Options --\> Editor --\> Behavior --\> click the check box for 'Copy text in rich text format'.

Thanks,
