I.  How to make your Contact Page send response to your Outlook Email

 I.  How to make your Contact Page send response to your Outlook Email

This Link will will take you to the webpage used to create the instructions below.

It will give you detailed instructions

(Thanks to Lori Nicholas)

If you are reading this, you should have already created your Contact Page and the Response Spreadsheet that goes with it.  These instructions will begin at that point.

1.  Go to your 'View Responses' spreadsheet by either finding it in your 'My Drive' or open your Contact Form in your 'My Drive' and click the button 'View Response' at the top.

2.  On the 'Responses' page, change the name of your page (if desired) by moving cursor over the name and delete it, then retype new name.

3.  Once in the spreadsheet use the Tools menu, then Script editor...

4.  In the Google Apps Script dialogue box choose to make a Blank Project.

5.  If desired, change the name of the script.  Deleted the mess that is in the content area of the window and copy and paste the script in the (now) blank space shown below the image.

SCRIPT TO COPY AND PASTE:

function nl2br_(input_string){

  return input_string.replace(/(\r\n|\r|\n)/g,'<br />');

}

function contactUsMailer(e) {

  //  This script e-mails the contents of a form to a given recipient

  //  The form must have three fields in the order of: name; e-mail address; and message

  //  You must change the recipient variable below to your e-mail address

  try {

    var recipient = '';

    var timestamp = e.values[0];

    var name = e.values[1];

    var email = e.values[2];

    var message = e.values[3];

    var body = name+' <'+email+'> sent the following message: '+message;

    var bodyHTML = '\

        <p>'+name+' <a href="mailto:'+email+'">'+email+'</a> sent the following message: </p>\

        <blockquote>'+nl2br_(message)+'</blockquote>\

        <p>Sent by the <a href="http://www.steegle.com/">Steegle.com</a> Contact Us Form Google Apps Script</p>';

    var advancedArgs = {htmlBody:bodyHTML , replyTo:email};

    MailApp.sendEmail(recipient, "Contact Us Form", body, advancedArgs);

  } catch(e){

    MailApp.sendEmail(recipient, "Error - Contact Us Form", e.message);

  }

}

6.  In the 10th line, find:   var recipient = '';  Enter your email address (wcschools email) between the apostrophes.  It should look like this:   var recipient = 'presleym@wcschools.com';

7.  Save the Page

8.  While still in the Script Editor use the Resources menu, then Current project's triggers...

9.  In the Current Project's Triggers box, click No triggers set up. Click here to add one now.

10.  In the drop-down boxes, use the setting shown below then save it:

11.  If you get a box asking for 'Authorization', click 'Accept.

12.  Save your spreadsheet and close it.

13.  Go to your Contact Form and fill it out and submit it.  You should get an email with the response.  You will also have a record of the responses in the Google Drive Spreadsheet.

14.  Now, wasn't that easy?