Tried this.... but still only the last record is being displayed
<cfset newline = #chr(13)#&#chr(10)#>
<cfset pageOutput = "Last Name,First Name,Address,City,State,Zip,E-Mail"&newLine>
<cffile action="write" file="D:\Webs\wwwroot\NGSInternal\Lapse.csv" output="#pageOutput#" addnewline="no">...