# Toad Data Point 3.4 - How do I format output in excel

**URL:** <https://forums.toadworld.com/t/toad-data-point-3-4-how-do-i-format-output-in-excel/29058>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [February 28, 2014, 9:13am UTC](https://forums.toadworld.com/t/toad-data-point-3-4-how-do-i-format-output-in-excel/29058 "2014-02-28T09:13:54Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Anonymous1](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Anonymous1](https://forums.toadworld.com/u/Anonymous1)\
**Post date:** [February 28, 2014, 9:13am UTC](https://forums.toadworld.com/t/toad-data-point-3-4-how-do-i-format-output-in-excel/29058/1 "2014-02-28T09:13:54Z")

</div>

I have spent about 20hrs trying to do the following:

After my SQL script is run and the the output is sent to excel, I format the out put and then email myself the report (automation) but the formatting file never gets emailed. I ALWAYS receive the email without the excel formatting I did.

Is it possible to save the formatting of the excel file so I can email out my reports to a distribution list?

Thanks  
Neil

---

<div class="post-metadata">

**Author:** ![spligosh](https://avatars.discourse-cdn.com/v4/letter/s/e68b1a/32.png) [@spligosh](https://forums.toadworld.com/u/spligosh)\
**Post date:** [March 5, 2014, 7:39am UTC](https://forums.toadworld.com/t/toad-data-point-3-4-how-do-i-format-output-in-excel/29058/2 "2014-03-05T07:39:34Z")

</div>

I think the easiest way to do this is to have an excel macro which does your formatting. You can then call the macro after you have done the export from wihtin TDP. How are you emailing the report?

---

<div class="post-metadata">

**Author:** ![Anonymous1](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Anonymous1](https://forums.toadworld.com/u/Anonymous1)\
**Post date:** [March 5, 2014, 7:58am UTC](https://forums.toadworld.com/t/toad-data-point-3-4-how-do-i-format-output-in-excel/29058/3 "2014-03-05T07:58:45Z")

</div>

spligosh, I actually just started looking at macro formatting, thanks for the help.

My goal is to email the report through TDP but until I can format my reports I am just dumping them to my desktop and then working on them.

---

<div class="post-metadata">

**Author:** ![Kiki](https://avatars.discourse-cdn.com/v4/letter/k/dc4da7/32.png) [@Kiki](https://forums.toadworld.com/u/Kiki)\
**Post date:** [March 5, 2014, 3:11pm UTC](https://forums.toadworld.com/t/toad-data-point-3-4-how-do-i-format-output-in-excel/29058/4 "2014-03-05T15:11:24Z")

</div>

We have a new feature in 3.4 release which allows setting the format in "Select columns" page in export wizard. Hope this helps.

 ![formatColumnPage.png](https://global.discourse-cdn.com/quest/original/2X/6/680202dc53b627c88e0b6d57d0e3af6f46634276.png)

---

<div class="post-metadata">

**Author:** ![Anonymous1](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@Anonymous1](https://forums.toadworld.com/u/Anonymous1)\
**Post date:** [March 6, 2014, 6:50am UTC](https://forums.toadworld.com/t/toad-data-point-3-4-how-do-i-format-output-in-excel/29058/5 "2014-03-06T06:50:07Z")

</div>

Kiki thanks for the response, I was looking more to fomat the data in the way I could dump the raw data to one excel sheet and then create 2 or 3 reports from it.

---

<div class="post-metadata">

**Author:** ![Kiki](https://avatars.discourse-cdn.com/v4/letter/k/dc4da7/32.png) [@Kiki](https://forums.toadworld.com/u/Kiki)\
**Post date:** [March 6, 2014, 4:47pm UTC](https://forums.toadworld.com/t/toad-data-point-3-4-how-do-i-format-output-in-excel/29058/6 "2014-03-06T16:47:04Z")

</div>

As spligosh suggested, macro in Excel may works for you.