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/HTMLFormsFromBookJavaServletsDevelopersGuide.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, not is not yet implemented (Oct-2008)

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 is part of our advanced service. The cost is $15/month.

/advanced-submit-service

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 HTML files to a few people. When they open them they are opening them in their 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.

If you decide to continue to use it, and want to enable the full Advanced Service, contact sales@spreadsheetconverter.com

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

You can read about our submit support here

/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:

/manual

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 button 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.

How would you go about setting up different Forms with different email addresses for Submit?

Example – Some forms would go top Bob is shipping, another to Sally in accounting and yet another to Harry in IT. Is there a way to change the email addresses locally?

You need to request one receiver code for each email address, and then have that receiver code entered in the wizard when you generate the form.

Where can I change the e-mail of the Advanced Service to where the forms are send to?

The Advanced Service consists of two parts

1. The email looks like the web page

2. The fields are stored in a database for later retrieval.

You get 1. by selecting Advanced Service in the SpreadsheetConverter wizard

You get 2. by using a receiver code for an email address that is known to SpreadsheetServer.

When we set up the Advanced Service account for you, you got one login + password. Create a new user for the second email address whose submits you want to store, request a receiver code for this second email address, enter it into the wizard, convert and publish.

Try this Excel add-in now!

Click on Download to install and test this Excel add-in for Windows.

Click on Upload to let us convert a spreadsheet for you for free.