Sending mail in CSV format

[Guest]

i have created a access form which sends a pre created query to other dept
in XLS format but i want to change the format to CSV i tried using
acformatcsv instead of acformatxls but it don't work. Do anyone have any idea
on how can i send it in CVS format.

 

[Arvin Meyer [MVP]]

Try using acFormatTXT

 

[Guest]

Hi Thanks Arvin
I tried using acformattxt. The code creates a file in txt format the problem
with that is.

1. The text file has a dotted box around the column heading. Which shows up
in the csv file

2. The receiver on the other end will have to go through delimiting process
which I want to avoid. I was trying to find a way through which I can
directly send the file in CSV format. E.g. xyz.csv

 

[Guest]

Hi Thanks Arvin
I tried using acformattxt. The code creates a file in txt format the problem
with that is.
1. The text file has a dotted box around the column heading. Which shows up
in the csv file

2. The receiver on the other end will have to go through delimiting process
which I want to avoid. I was trying to find a way through which I can
directly send the file in CSV format. E.g. xyz.csv

 

[Guest]

Hi Thanks Arvin
I tried using acformattxt. The code creates a file in txt format the problem
with that is.
1. The text file has a dotted box around the column heading. Which shows up
in the csv file
2. The receiver on the other end will have to go through delimiting process
which I want to avoid. I was trying to find a way through which I can
directly send the file in CSV format. E.g. xyz.csv