I have a unix script that runs a SQL on Oracle and mails the results. The results are very well formatted when i check the spool file in Unix... but the mails looks totally wacky.... The columns do not allign with the headings.... Can anyone help me to make this allign... !!!

Thanks in advance...

My guess is that the UNIX machine is displaying with a fixed-width font and Outlook is not. This will cause the columns to be misaligned.

One option is to have the receivers view the email with a fixed-width font.

Another option:
I have a report that I send that had the same problem and I fixed this by sending it as an HTML file. To do this, I put a special line at the beginning of the file to tell Outlook that this is an HTML file and then coded the file as a webpage (complete with HTML & TABLE tags).

The first line of the email body should be:

content-type: text/html

The second line should be blank and the following lines are HTML code.

For example (I'm going to leave out the less than & greater than signs to make it easier to post the code here):

content-type: text/html

HTML
BODY
CENTER
Hello!
/CENTER
/BODY
/HTML

Don,
Thanks for your help... I figured out the way to solve this...

Earlier i was using "cat" to attach my results to the "mailx" function. The problem is because Unix was not converting all the tabs into spaces when it was sending out the mail. Using "Expand" rather than "Cat" solved my problem.

Anyway thanks for your reply....