|
|
|
Saving Data To A Spreadsheet
Q: |
I built my own Web site
using Microsoft FrontPage. I currently have a form set up
that collects user information (name, email address, etc.) and
emails that information to me. The problem is that at the end of the
month, I have to go through all of the emails, type them all into
Excel, and then send out my mailings. This is quite a tedious
process. Is there any way to get FrontPage to save this information
in a database or spreadsheet format so I don't have to
retype everything? >Jennifer, Boston MA
|
A: |
Jennifer, we cover this
topic in our
Microsoft FrontPage 201 course. If you go into the Form
Properties, click on the Options button. You'll see a
bunch of tabs. The first tab is called "File Results." On here, you
can specify a filename to save the data to on your server. Just
enter in a file name (recommended in your _private folder)
and specify one of the text database formats. I like the "text
database using tab as a separator" format because you can copy and
paste the results directly into Excel and it keeps all of your data
nicely in columns. Try it out. |
By Richard Rost
Click here to sign up for more FREE tips
|