Allright the CSV problem is solved. The first issue was the fact that the output of sql plus, while I used the colsep set to '","' worked properly, the beginning of the line and the end of the line were not quoted. So I thought I was working with:
But was actually working with:
The other problem was that for some reason the 'attachment' file began with a ^Z after encoding it. This means that the very first line of the attachment did not start with "begin 644 list.csv" like MIME header restrictions require. After removing that ^Z, the file attaches properly. If you are wondering if that is the case with your email, try running a cat on it but make sure you show all non-visible characters. I think the switch is -t but I'm not entirely sure. Anyway, here's how I run it now, and this works:

Code:

# Encapsulate each line with quotes in order to balance the quotes from the sql output
# Also deletes first line which is essentially blank
sed 's/^/"/;s/$/"/;1d;s/        //' list.prt > list.quoted

# Convert the file to dos format, but delete the strange control Z at the beg of the file
ux2dos list.quoted | sed '1s/^Z//' > list.prt.dos

# Encode the dos formatted file into CSV format as the attachment
uuencode list.prt.dos list.csv > Attachment

# Concat the attachment and the body together for sending
cat list.prt.dos Attachment > Message

# Send the message
mailx -m -s "subject" me@here.com < Message

So back to the first problem.
Here's what I've got so far:

Code:

function csv2mail {

awk  '{
        FS = '\",\"'
        if (NR==1){
                for (col=1; col<=NF; col+=1) {
                        head[col]=$col
                }
        } else {

        for (col=1; col<=NF; col+=1) {
                printf("%s: %s\n",head[col], $col)
        }
        }
}' $1
}

csv2mail list.prt > Body

Problem is that it isn't printing right. It seems to run the second for loop for each record including the first record, but each time the 'head' array is blank, so instead of getting:
All I get is: