Trick: ‘Pasting’ SQL Developer Exports to an Outlook Message as an HTML Table

thatjeffsmith SQL Developer 3 Comments

Tell Others About This Story:

You have some data.

You want to email it to someone.

You don’t want them to have to open an attachment.

You want it to be in an HTML-Tabl’ish delivery device.

In SQL Developer, write your query.

Export to HTML > File.

Open Outlook.

Start your message.

Attach File

Point to your HTML File

DON’T CLICK ON THE INSERT BUTTON

On the INSERT button, there’s a drop-down widget. Click that instead. And then choose, ‘Insert as Text.’

Ta-da?

Ta-da?

Our generated HTML has an some javascript which adds a search mechanism to your webpage. That will render as an ugly red box in your email message…just backspace over it.

I realize this is a few extra clicks than you might want, but it’s probably still faster than what you’ve been doing.

Tell Others About This Story:

Comments 3

  1. Is there a way to override the CSS used in the export? I find myself hand-editing the exported html file every time to get rid of the “width: 100%” in the table CSS.

    1. thatjeffsmith Post
      Author
  2. If nice HTML formatting is not so important, and Excel is available, I find following steps convenient (similarly, new email message windows is assumed to be open):

    – Ctrl-A (select all rows in SQL Developer results table)
    – Ctrl-Shift-C (copy selected; including header row)
    – Alt-Tab (or WindowsKey and type ‘excel’-Enter) (switch to opened Excel)
    – Ctrl-V
    – Ctrl-C (this time, table format is also on clipboard)
    – Alt-Tab (switch to opened new message window)
    – Ctrl-V

    Cheers

Leave a Reply

Your email address will not be published. Required fields are marked *