Frontpage form data via email

  • Thread starter Thread starter skc
  • Start date Start date
S

skc

I have designed a webform on the web. Anyone can fill-in
the web form. Instead of the form being saved to a
database (access2000 or similar), I have specified an
email address which works quite well.

What I get back is a list of my fields on the left with
the stuff people have filled in to the right. I also
ticked the browser name, timestamp etc... so it picks this
up too.

What I now want to do is import the email results from
Outlook 2000 into a database or Excel, formatted with
textbox fields in one column and data in the next column.
Better still, I would like to import this into a database
such as Access2000.

Can someone give me any pointers for this. Although I am
probably getting 2 or 3 forms a day by email, there are
around 60 fields in the webform. Someone out there must
be getting hundreds of emails from web forms which they
must be able to sort out for statistics etc...so please
can you help!!

Thanks,

skc
 
You can also save the results to a text file (tab delimited csv) and periodically open your live site in FP and copy that to your
desktop (Excel or Access will handle the csv files)
Form Properties Option and set the save results to an existing file in the _private folder
Or File New page and select the Forms Wizard

Or to use ASP to write to a database see
http://support.microsoft.com/default.aspx?scid=kb;en-us;275251

--




| I have designed a webform on the web. Anyone can fill-in
| the web form. Instead of the form being saved to a
| database (access2000 or similar), I have specified an
| email address which works quite well.
|
| What I get back is a list of my fields on the left with
| the stuff people have filled in to the right. I also
| ticked the browser name, timestamp etc... so it picks this
| up too.
|
| What I now want to do is import the email results from
| Outlook 2000 into a database or Excel, formatted with
| textbox fields in one column and data in the next column.
| Better still, I would like to import this into a database
| such as Access2000.
|
| Can someone give me any pointers for this. Although I am
| probably getting 2 or 3 forms a day by email, there are
| around 60 fields in the webform. Someone out there must
| be getting hundreds of emails from web forms which they
| must be able to sort out for statistics etc...so please
| can you help!!
|
| Thanks,
|
| skc
 
Is the _private folder protected?
-----Original Message-----
You can also save the results to a text file (tab
Click to expand...
delimited csv) and periodically open your live site in FP
and copy that to your
desktop (Excel or Access will handle the csv files)
Form Properties Option and set the save results to an
Click to expand...
existing file in the _private folder
Or File New page and select the Forms Wizard

Or to use ASP to write to a database see
http://support.microsoft.com/default.aspx?scid=kb;en- us;275251

--




"skc" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
Back
Top