Solved

Email a csv file from a form

Posted on 2006-11-06
5
137 Views
Last Modified: 2013-12-24
I have a form created in ColdFusion. I am emailing the results of the form. All is working great. I need to add a function that will also allow me to email the form fields to a specied user in a csv format. Any help will be greatly appreciated.
0
Comment
Question by:aspiegel
  • 2
  • 2
5 Comments
 
LVL 15

Expert Comment

by:danrosenthal
ID: 17883014
How about writing the results to a file and attaching the file to the email using CFMAILPARAM?
0
 

Author Comment

by:aspiegel
ID: 17884246
What is the best way to write an excel file(csv) and also still email the form to the user?
0
 
LVL 15

Expert Comment

by:danrosenthal
ID: 17884277
I would start with <CFFILE>

0
 
LVL 13

Accepted Solution

by:
usachrisk1983 earned 250 total points
ID: 17895109
Use CFFILE with an ACTION of WRITE to put the data you need into a file.  Keep the file outside of the public website, if possible -- you can probably use the temporary directory for this.  Then, just use CFMAIAL with the CFMAILPARAM tag nested inside to mail the file to the user.  I would recommend not deleting the file immediately, since depending on your CF mail spool settings, you may end up deleting the file before the mail server is able to grab it to send out.
0
 

Author Comment

by:aspiegel
ID: 17899080
That worked great. Thanks for your help.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Now that Expression Web 4.0 (http://www.microsoft.com/expression/products/Upgrade.aspx) is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
One of the typical problems I have experienced is when you have to move a web server from one hosting site to another. You normally prepare all on the new host, transfer the site, change DNS and cross your fingers hoping all will be ok on new server…
The purpose of this video is to demonstrate how to create a Printer Friendly PDF on a WordPress Page. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome Screenshot” Google Chrome Extension, and SmallPDF.com Log…
The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now