Emailing database results

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
|
 
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.
 
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.
 
Back
Top