Send object function with a CSV file

[Stephane]

Hello,

We're using the send object function in a Macro to output a table in Excel
97-2003 file and send the file by email to our customers.

I was wondering, how can we achieve that using the same "Send Object"
function but with a csv file ?

My table name is "Monthly Report" and I would like to output like this
"Monthly Report.csv" using ";" as delimiter.

Thanks

Stephane

 

[Steve Schapel]

Stephane,

CSV stands for comma separated values. It doesn't make a lot of sense to
try and use semi-colons as the delimiter, as the csv file definition calls
for commas.

 

[Stephane]

Stephane,

CSV stands for comma separated values. It doesn't make a lot of sense to
try and use semi-colons as the delimiter, as the csv file definition calls
for commas.

Steve,

Thanks for the reply. The thing is since we're using French as a language in
our report instead of "dot" for decimals, our system use a comma.

This is why, our CSV is ";" and not ",".

Regards

Stephane

 

[Luc]

Stephane

I am in Belgium and have the same problem. I need to output some data into a
csv file format to email to a client. The only way I can figure it out to do
is to have one long string in a query putting each field into the one
string, with &","& or &";"& between each value. But for the ?5,55 type of
values I don't know how it will be read if I use a comma to separate the
fields. Also, I want to use an Access macro to output and email the file,
using SENDOBJECT, but I still need to define a file type and csv isn't an
option !

How did you fix this ?

 

[Stephane]

Actually, knowing some basics VBA in Excel, you can output the table with any
delimiter once you have the code.

All I know is to create some forms.

Thanks

Stephane