RE: Formatting an EXCEL Worksheet Generated From The 400

Recently, an associate, Ricky Thompson, gave me this tip. 
He said, MS Excel will open a text file, formatted as an HTML 
table, without any intervention if the file has a .xls extension. 
Try it. Paste the HTML below into notepad and save it with the 
.xls extension then open it in Excel.

You'll just need to create a the file with HTML table tags instead 
of a CSV file. I'll leave that as an exercise for the reader. :)

<table border="1">
<tr><td><b>Product Id</b></td><td><b>Description</b></td><td><b>On
Hand</b></td><td></tr>
<tr><td align="left">WIDGET-A</td><td align="left">A
Widget</td><td>0</td></tr>
<tr><td align="left">WIDGET-B</td><td align="left">B
Widget</td><td>255</td></tr>
</table>

HTH

Reggie Acosta
Brown Jordan International


>....however automation between the mailing out and the end-user 
> opening it up in EXCEL would be great!!
> 
> Any ideas people?
> 
> Thanks much.
> 
> Rick Rayburn
> NYC