Exporting data to a CSV or/and emailing

[Guest]

I have a database of members and a cf page which produces a query based upon certain criteria (eg mailing options chosen / sex etc.)

I have the query getting the correct data but how do I go about emailing those members and/or exporting data from the query to an excel spreadsheet, csv or access database file.

Are there any pointer you can give be because this is completely new. (although I have used cfmail)

Many thanks in advance.

[Guest]

Use CFHEADER and CFCONTENT to create an Excel spreadsheet. See below.

[Guest]

Sorry I dont understand what that is. do I need to instal something extra ont he server to get it to work? Whats the vnd file? And as there isnt an end tag, how will it know how much data to produce?

[Guest]

I suggest you go to http://livedocs.macromedia.com/coldfusion/5.0/CFML_Reference/Tags12.htm#1097761 and learn about CFCONTENT. Same goes for CFHEADER at http://livedocs.macromedia.com/coldfusion/5.0/CFML_Reference/Tags45.htm#1355655. The answer to some of your questions are there.

You only need to place the sample code into a file with a .cfm extension and run it on your ColdFusion server. You will see that each table cell is an Excel cell.

[Guest]

Thanks jdeline, I have no idea what those tags do.

[Guest]

So did you read the documentation about the tags at the links I provided? Did you run the sample code?