Email

Can I send the web page as an interactive HTML-email?

Yes, you can send it. However, most email programs ignore JavaScript in email, and therefore recalculation will not work. JavaScript is disabled to prevent infection from viruses. Therefor it is better to publish the web site and email the link.

I do not want to use FrontPage server extension, any alternatives?

You can use our free or advanced service.

If your web server supports Perl, formmail.pl is an alternative. See http://www.formmail.com/

If you use a Windows server, look at formmail.asp

http://www.sortedsites.com/software/formmail.asp

or if you prefer ASP.NET

http://notebook.arkane-systems.net/index.php/Formmail_in_ASP .NET

If you use PHP, here are some

http://www.dtheatre.com/scripts/formmail.php

http://www.hotscripts.com/Detailed/29699.html

For Java, see

http://www.hotscripts.com/Detailed/21178.html

http://www.hotscripts.com/Detailed/6177.html

and "Java Servlets Developer's Guide" published by McGraw-Hill/Osborne Media Group

http://www.java2s.com/Code/JavaDownload/HTMLFormsFromBookJav aServletsDevelopersGuide.zip

I requested a receiver code but I did not get an email with the codes.

If you entered the email address correctly - you can try a second time - then most likely AOL has decided that the email with the receiver code is spam and has deleted it.

You have to try another email address.

What if I want a customer to receive a copy of what they submitted? How do I get the submitted data to come to me and them?

This will be part of the advanced service.

In order to prevent spammers to use your form to send spam to arbitrary email addresses, we have to make sure that there a human who submitted the form.

Before sending the copy to the submitter, he/she will have to enter a security code similar to the code at

https://secure.overture.com/s/dtc/center/?mkt=us

Suppose I survey 2000 students. I get 2000 e-mails. Do you have a macro or quick way to get the results back into a spreadsheet?

That functionality will be part of our advanced service. The cost will be $10-$20/month and we hope to launch it before end of this year.

An alternative is to configure your own webserver, for example Frontpage extension can collect submitted data into a CSV-file, which easily is opened by Excel.

I have sent some htlm files to a few people. When they open them they are opening them in there email page how can I make this stop happening?

Instead of attaching the HTML-files, attach the ZIP-file that SpreadsheetConverter generates. This will solve your problem and make the email much smaller. Then you have to tell the user to open the zip file, extract the files and click on the HTM-file.

How do I apply for the advance service?

Request a receiver code and check the advanced service. The receiver code for the free service and the advanced service is the same.

Before we start charging for the service, we will contact you by email.

How do I create a submit form so that the form information goes to an email?

You can read about our submit support here

http://www.spreadsheetconverter.com/excel_form_submit_email. htm

Then, you create a form using Excel, start SpreadsheetConverter and select 'Submit'-button under 'Configure toolbar'.

The first time you add a submit button, you will have to request a receiver code, so that we know where to send the email.

The relevant section in the manual is found here:

http://www.spreadsheetconverter.com/manual/SpreadsheetConver ter%20Users%20Guide.htm#dialog_toolbar

Why can't I enter a mailto:-link, why do I need to submit through a webserver?

The contents of a web form cannot be emailed directly. You need to add a submit-button, the submit-button will send the data to a server, and the server can for example email the entered values.

Why do I get an email with fields with names lie p2C144?

If you name the cells in Excel, those names will be used instead of p2C144

The email with submitted data names the fields like p1A3, p1D3, p1E3

The email looks like this:

p1A3: 5 p1D3: 9,50 p1E3: 47,50

If you name the individual cells in Excel, these names will be used as names. Note that they must start with a letter, and only contain letters, digits and "_".

Also note that the Advanced Service sends you a snapshot of the whole form as it looked to the user.

I want the form to be emailed to different persons depending on the value of a dropdown list.

So in other words, there isn't anything to where we can add to the excel spreadsheet that would have a down down menu with a list of email addresses and when its submitted it would get sent in conjunction with the notice to whoever would get that, also to the person or persons selected for the drop down list in the spreadsheet??

The email is always mailed to the same address, at least if you use our Advanced or Free Service.

A workaround is to mail it to the same email address, and then have a filter in the email server that looks for a value and forwards the email to the right person.

Exchange and Outlook supports filters like this.

I will need to have the submissions sent to another email address, what do I do?

Request a new receiver code for the new email address, enter it into the wizard and regenerate the web page, and then publish the new page.

Can the submit buttom be configured to send an auto response to the person submitting the form as well as to me?

No, not directly.

However, if you named the cell in Excel where the user enters his email address "email", you can set up an auto-responder on your own email address.


Email Can I send the web page as an interactive HTML-email? Yes, you can send it. However, most email programs ignore JavaScript in email, and therefore recalculation will not work. JavaScript is disabled to prevent infection from viruses. Therefor it is better to publish the web site and email the link. I do not want to use FrontPage server extension, any alternatives? You can use our free or advanced service. If your web server supports Perl, formmail.pl is an alternative. See http://www.formmail.com/ If you use a Windows server, look at formmail.asp http://www.sortedsites.com/software/formmail.asp or if you prefer ASP.NET http://notebook.arkane-systems.net/index.php/Formmail_in_ASP .NET If you use PHP, here are some http://www.dtheatre.com/scripts/formmail.php http://www.hotscripts.com/Detailed/29699.html For Java, see http://www.hotscripts.com/Detailed/21178.html http://www.hotscripts.com/Detailed/6177.html and "Java Servlets Developer's Guide" published by McGraw-Hill/Osborne Media Group http://www.java2s.com/Code/JavaDownload/HTMLFormsFromBookJav aServletsDevelopersGuide.zip I requested a receiver code but I did not get an email with the codes. If you entered the email address correctly - you can try a second time - then most likely AOL has decided that the email with the receiver code is spam and has deleted it. You have to try another email address. What if I want a customer to receive a copy of what they submitted? How do I get the submitted data to come to me and them? This will be part of the advanced service. In order to prevent spammers to use your form to send spam to arbitrary email addresses, we have to make sure that there a human who submitted the form. Before sending the copy to the submitter, he/she will have to enter a security code similar to the code at https://secure.overture.com/s/dtc/center/?mkt=us Suppose I survey 2000 students. I get 2000 e-mails. Do you have a macro or quick way to get the results back into a spreadsheet? That functionality will be part of our advanced service. The cost will be $10-$20/month and we hope to launch it before end of this year. An alternative is to configure your own webserver, for example Frontpage extension can collect submitted data into a CSV-file, which easily is opened by Excel. I have sent some htlm files to a few people. When they open them they are opening them in there email page how can I make this stop happening? Instead of attaching the HTML-files, attach the ZIP-file that SpreadsheetConverter generates. This will solve your problem and make the email much smaller. Then you have to tell the user to open the zip file, extract the files and click on the HTM-file. How do I apply for the advance service? Request a receiver code and check the advanced service. The receiver code for the free service and the advanced service is the same. Before we start charging for the service, we will contact you by email. How do I create a submit form so that the form information goes to an email? You can read about our submit support here http://www.spreadsheetconverter.com/excel_form_submit_email. htm Then, you create a form using Excel, start SpreadsheetConverter and select 'Submit'-button under 'Configure toolbar'. The first time you add a submit button, you will have to request a receiver code, so that we know where to send the email. The relevant section in the manual is found here: http://www.spreadsheetconverter.com/manual/SpreadsheetConver ter%20Users%20Guide.htm#dialog_toolbar Why can't I enter a mailto:-link, why do I need to submit through a webserver? The contents of a web form cannot be emailed directly. You need to add a submit-button, the submit-button will send the data to a server, and the server can for example email the entered values. Why do I get an email with fields with names lie p2C144? If you name the cells in Excel, those names will be used instead of p2C144 The email with submitted data names the fields like p1A3, p1D3, p1E3 The email looks like this: p1A3: 5 p1D3: 9,50 p1E3: 47,50 If you name the individual cells in Excel, these names will be used as names. Note that they must start with a letter, and only contain letters, digits and "_". Also note that the Advanced Service sends you a snapshot of the whole form as it looked to the user. I want the form to be emailed to different persons depending on the value of a dropdown list. So in other words, there isn't anything to where we can add to the excel spreadsheet that would have a down down menu with a list of email addresses and when its submitted it would get sent in conjunction with the notice to whoever would get that, also to the person or persons selected for the drop down list in the spreadsheet?? The email is always mailed to the same address, at least if you use our Advanced or Free Service. A workaround is to mail it to the same email address, and then have a filter in the email server that looks for a value and forwards the email to the right person. Exchange and Outlook supports filters like this. I will need to have the submissions sent to another email address, what do I do? Request a new receiver code for the new email address, enter it into the wizard and regenerate the web page, and then publish the new page. Can the submit buttom be configured to send an auto response to the person submitting the form as well as to me? No, not directly. However, if you named the cell in Excel where the user enters his email address "email", you can set up an auto-responder on your own email address.
Copyright © Framtidsforum I&M AB, Sweden