Want to email data as a CSV file

[David Gartrell]

Hi there,

I hope someone can help me with this

Basically I need to be able to email our client with some data produced by a
query on an Access 2000 database. The only problem is it *has* to be in csv
format, and the 'sendobject' command does not support this file type.

I could use the transfertext function to export the data as a CSV file but
the 'sendobject' command won't accommodate attachments either.

If anyone can help me with this then i'd be very very grateful.

Many thanks.

David.

P.S if you can recommend any other Newsgroups i could post this to then
please let me know.

 

[Arvin Meyer]

SendObject won't work, but you can use your mail client. For Outlook, have a
look at the code here:

http://www.datastrat.com/Code/OutlookEmail.txt
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Krip]

David,

Check out Gadami from Kripsoft (http://www.kripsoft.com). Gadami will
let you run a query against an Access database and email the results in
a CSV file.

-Krip