Emailing database results

[Guest]

I am collecting a name and an email address in a form. This information will
be used for a mail merge into Word.

I selected text database using comma as a separator. I had hoped that the
data would get emailed as an attached csv file. Instead I just get the text
in the body of the email like this in a test form:

"attyname","email","B1"
"john smith","(e-mail address removed)","Submit"

First, is there anyway to automatically get the file emailed as an
attachment? If not, is there a way to copy this data into an Excel sheet
into separate cells based on the comma?

I dont want to use a database as it raises permissions issues on the
serverand the end user is familiar with mail merges of Excel and Word.

 

[Rob Giordano \(Crash\)]

copy the csv file off your server, then open it with Excel on your local hd.


|I am collecting a name and an email address in a form. This information
will
| be used for a mail merge into Word.
|
| I selected text database using comma as a separator. I had hoped that the
| data would get emailed as an attached csv file. Instead I just get the
text
| in the body of the email like this in a test form:
|
| "attyname","email","B1"
| "john smith","(e-mail address removed)","Submit"
|
| First, is there anyway to automatically get the file emailed as an
| attachment? If not, is there a way to copy this data into an Excel sheet
| into separate cells based on the comma?
|
| I dont want to use a database as it raises permissions issues on the
| serverand the end user is familiar with mail merges of Excel and Word.
|

 

[Ronx]

Copy the email into notepad.
Delete the extra bits, and save where the file can be found easily.
In Excel, use Data->Import External Data->Import Data
Select Text files on the bottom dropdown, and browse to the file.
Follow the Wizard to format the fields/columns.

 

[Guest]

Thanks Ron

That worked easily and I think my end users will understand

And this will give me time to write this as a SQL database and use SQL query
within Excel directly.