Sending Form Results to a Spreadsheet & Emailing an Account

[L_111]

I can set up a form fine, and (correct me if I'm wrong), I can get the form results sent to an Excel document by following the instructions in this guide: Build a record insert page in Dreamweaver CS6 .

Is it possible to make the submit button send an email, as well? If so, how do I change the content of the email so it only tells the recipient that the spreadsheet has been updated? Just to be sure, will Excel work or would I have to use Access?

If it's worth mentioning, I'm using Dreamweaver CC2015

Thanks!

[BenPleysier · Accepted solution]

Without going into details, the article that you refer to is outdated and should not be used in today.

What you are asking for can be done when using a server side coding language, The preferred language is PHP and the preferred database is MySQL..

When a form is submitted, it is redirected to an action script. This script can be found  a separate document. Within that script, you can tell the server to send and email and to send the form data to the database.

From you question I assume that this is new to you, so I suggest that you tackle the problem in three parts, namely

• learn what a form is and does
• learn how to send an email
• learn how to insert the data into a database

To learn about MySQL databases see PHP: MySQL Database

[L_111]

Thanks! I should be able to get it to work now.