Email table in text file format

[Jatz_DA_WAY]

Hi,
I am trying to email a table in text format using :

DoCmd.SendObject acSendTable, "Table", acFormatTXT, , , , "Results", "Attached are the reslts"

It sends the file in text file format, but it adds "-" & "|" characters all over the file. Is there a way that I can send the file in simple "Comma Separated" file format.

Thx,

Jatz

 

[Ron_dK]

I haven't tried this but maybe this will do :

DoCmd.SendObject acSendTable, "Table", acFormatCSV, , , , "Results", "Attached are the reslts"