Back to Top

Send Emails from Your Form Responses

 

Microsoft Forms, Google Forms, and Formstack can all email you when someone responds and thank people when they submit. When you need to send each person a personal follow-up later, mail merge turns your responses into individual emails. This guide covers both, for all three tools, whether your KAUST email is on Outlook or Gmail.

KAUST IT reviews and updates its guides regularly, but Microsoft, Google, and Formstack change their apps often. A button, menu, or name may look different from what you see here. If it does, look for a similar option or check the guides under Learn more.

Automatic emails or mail merge?

 

Both fill in details from each response, such as a name or a session. The difference is when they send and who they come from.

Automatic emails
  • You set them up once in the form.
  • They send the moment someone responds.
  • They come from the form tool, not your mailbox.
  • Best for: alerts to you, receipts, and confirmations.
Mail merge
  • You write one message and connect it to your responses.
  • It sends when you are ready, to the people you choose.
  • It comes from your KAUST mailbox, so replies come to you.
  • Best for: reminders, schedule changes, next steps, and follow-ups.

What each form tool can do

 

All three can collect responses and email you about them. They differ most in how much you can customize what people receive.

Microsoft FormsGoogle FormsFormstack
Who can use it at KAUSTEveryone with a KAUST Microsoft 365 accountEveryone with a KAUST Google accountFormstack license holders
Email to you when someone respondsYesYesYes, to you, your team, or routed recipients
Email to the person who respondedA receipt of their answersA copy of their responseUp to three confirmation emails
Write your own email messageNot built in. Use Power Automate.Not built inYes, with fields from the response
Thank-you message on screenYesYesYes, with fields from the response
Redirect to a web page after submittingNo. Add a link in the thank-you message.No. Add a link in the confirmation message.Yes
Responses in a spreadsheetOpen in ExcelLink to Google Sheets, or download a CSVExport to Excel or CSV

Microsoft Forms

 

Open your form, then open its Settings (the gear icon, or ... > Settings).

Get an email for each response

Turn on Get email notification of each response. You receive an email each time someone submits.

Give respondents a receipt

Turn on Allow receipt of responses after submission. People can save or print a PDF of their answers from the thank-you page. People who sign in with a KAUST account can also ask for an email receipt.

Customize the thank-you message

Under Customize thank you message, type what people should see after they submit, such as next steps or when they will hear from you. Microsoft Forms cannot redirect people to another page, so add a web address to the message instead.

Send your own email to each respondent

Microsoft Forms cannot send a custom email on its own. Power Automate can, using standard connectors included with your KAUST Microsoft 365 license:

  1. 1
    Select Create > Automated cloud flow, choose the trigger When a new response is submitted (Microsoft Forms), and select Create. Choose your form.
  2. 2
    Add Get response details and choose the same form. For Response Id, insert Response Id from the dynamic content list.
  3. 3
    Add Send an email (V2) (Office 365 Outlook). Insert the respondent's email address in To, and add answers from the response to the subject and message.
  4. 4
    Save the flow and submit a test response to check the email.

To email the respondent, your form needs their address: restrict it to people in KAUST with Record name turned on, or ask for an email address in a question.

Microsoft guide: Adjust your form or quiz settings in Microsoft Forms.

Google Forms

 

Get an email for each response

On the Responses tab, open More (the three dots) and select Get email notifications for new responses.

Send respondents a copy of their response

  1. 1
    Select Settings and expand Responses.
  2. 2
    Set Collect email addresses to Verified (people sign in with Google) or Responder input (people type their address).
  3. 3
    Set Send responders a copy of their response to Always or When requested.

The copy lists their answers. You cannot write your own message for it.

Customize the confirmation message

Select Settings, expand Presentation, and next to Confirmation message select Edit. Type your message and select Save. Google Forms cannot redirect people to another page, so add a web address to the message instead.

Send your own email to each respondent

Google Forms has no built-in custom email. Link your responses to Google Sheets and use Gmail mail merge, or download them for Outlook. Add-ons from the Google Workspace Marketplace that send emails are third-party apps; contact KAUST IT before you connect one to KAUST data.

Google guides: View and manage form responses and Publish and share your form with responders.

Formstack

 

Formstack gives you the most control. Open your form and select Settings > Emails & Actions.

Notification emails, for you and your team

Sent each time someone submits, to you, team members, or the right person based on the answers (Email Logic). Include all submitted data, a link to the submission, or your own message with fields from the response. Set a reply-to address so replies reach the right inbox.

Confirmation emails, for the person who submitted

Your form needs an email field. You can send up to three confirmation emails per submission, each with your own message, fields from the response, and the submission ID as a reference number. Formstack cannot resend confirmation emails, so test them before you share the form.

Thank-you message or redirect

Under Submission Message, choose the Default Message, write a Custom "Thank You" Message with fields from the response, or choose Redirect to an External URL to send people to another page. Only one runs per submission.

Formstack guides: Notification Emails, Confirmation Emails, and Submit Actions.

Mail merge: personal follow-ups from your responses

 

Mail merge works the same way whichever form tool you use: get your responses into a spreadsheet, tidy the columns, write one message with placeholders, and send. Each person receives their own email with their details filled in.

  • Who this is for
    Anyone at KAUST who collects responses with Microsoft Forms, Google Forms, or Formstack.
  • Which mailbox you send from
    KAUST email on Outlook: use Word or Power Automate. KAUST email on Gmail: use Gmail mail merge. Not sure? See Microsoft Outlook at KAUST.
  • Personal, not bulk
    Outlook mailboxes send up to 30 messages a minute and 10,000 recipients a day; Gmail mail merge up to 1,500 a day. For larger audiences, contact KAUST IT first.
  • Protect the data
    Responses hold personal information. Keep only the columns you need, store the file in OneDrive or Google Drive, and delete it when you finish.

Step 1: Get your responses into a spreadsheet

Microsoft Forms
  1. 1
    Open your form and select View responses.
  2. 2
    Select Open results in Excel. The workbook is saved in OneDrive and updates as responses arrive.
  3. 3
    For a fixed copy, use the arrow next to it and select Download a copy.
Google Forms
  1. 1
    Open the Responses tab and select Link to Sheets.
  2. 2
    Create a new spreadsheet or choose an existing one. New responses are added automatically.
  3. 3
    For Outlook, open More and select Download responses (.csv) instead.
Formstack
  1. 1
    Sign in to KAUST Formstack, open your form, and select Submissions.
  2. 2
    Open Table Settings and keep only the columns you need in Visible Columns.
  3. 3
    Select Export All, or select submissions and Export. Choose Excel (.xlsx).

Mixing tools is fine. On Outlook with Google Forms responses? Download the CSV. On Gmail with Microsoft Forms or Formstack responses? Upload the Excel file to Google Drive and open it in Google Sheets.

Step 2: Prepare the file

  1. 1
    Keep only the columns you will use. Remove any column with an empty header, and remove test responses and duplicates. In Google Sheets, keep the data on the first tab.
  2. 2
    Rename headers to short, simple names with no spaces or symbols, such as FirstName, Email, and Session. All three tools use each question as a header, so a header can be a full sentence.
  3. 3
    Combine answers spread across several columns. Some questions export as one column per option, with only one filled in. Add a column such as Session and use =TEXTJOIN(", ",TRUE,C2:J2) to bring the filled-in value into one cell, then fill it down.
  4. 4
    Check that every row has an email address in the column you will send to.
  5. 5
    If Arabic names or special characters look wrong in a CSV, import it with UTF-8 encoding. For Word, save the file as an Excel Workbook (.xlsx); on macOS, close it before you merge.

What to expect in each export

ToolColumns you will usually seeWatch for
Microsoft FormsID, Start time, Completion time, Email, Name, then one column per questionName and email are filled in only when people sign in with a KAUST account. Otherwise ask for them in a question.
Google FormsTimestamp, Email Address if you collect it, then one column per questionGmail mail merge cannot read headers with special characters, so rename question headers.
FormstackTime, Name (First), Name (Last), Email, Unique ID, plus Browser, IP Address, LocationHide the browser, IP address, and location columns before exporting. Use Unique ID as a reference number.

Step 3: Send

Choose the section for the mailbox you send from. Write your message once, insert fields where details should change, test with your own address, then send to everyone.

Outlook on Windows: Word mail merge

 

Word sends mail merge messages through classic Outlook. The new Outlook for Windows does not fully support Word mail merge yet. If the New Outlook toggle at the top of Outlook is on, turn it off before you finish the merge.

  1. 1
    In Word, create a blank document. On the Mailings tab, select Start Mail Merge > E-mail Messages.
  2. 2
    Select Select Recipients > Use an Existing List, choose your file, and select Open. In Select Table, choose the sheet, keep First row of data contains column headers selected, and select OK.
  3. 3
    Write your message. Use Insert Merge Field to add columns such as FirstName, or Greeting Line for the greeting.
  4. 4
    Select Preview Results and check a few records.
  5. 5
    Select Finish & Merge > Send Email Messages. In To, choose the email column, type a Subject line, and keep Mail format as HTML.
  6. 6
    Test first with Current record on your own row. Then send All and watch Outbox and Sent Items.

Word uses the same subject line for everyone and cannot add attachments or Cc. Put links in the message instead of attaching files.

Outlook on macOS: Word mail merge

 

Make Outlook your default email app first: in Apple Mail, choose Mail > Settings > General and set Default email reader to Microsoft Outlook. Close your Excel file.

  1. 1
    In Word, create a blank document. On the Mailings tab, select Start Mail Merge > Email Messages.
  2. 2
    Select Select Recipients > Use an Existing List, choose your file, and select Open. In Open Workbook, choose the sheet and select OK.
  3. 3
    Write your message and use Insert Merge Field to add columns.
  4. 4
    Select Preview Results and check a few records.
  5. 5
    Select Finish & Merge > Merge to E-mail. In To, choose the email column, type a Subject, and set Send As to HTML.
  6. 6
    Test with your own record first, then send all records and watch the Outbox in Outlook.

If messages stay in the Outbox or nothing sends, do not run the merge again, because people could receive duplicates. Contact KAUST IT for help.

Outlook on the web: Power Automate

 

Word for the web has no mail merge, and the mail merge option Microsoft is adding to Outlook on the web cannot yet fill in fields from a spreadsheet. Power Automate can send one email for each row of an Excel table, from any browser.

Licensing: no premium license needed

These steps, and the Microsoft Forms flow above, use Power Automate (Standard), included with your KAUST Microsoft 365 license, and standard connectors only. The included license has a daily limit on flow actions, which is plenty for a few hundred emails.

If Power Automate shows a Premium label or asks you to upgrade, you have added a premium connector or feature. Learn what each license includes in Requesting Microsoft 365 Licenses. If you already know what you need, request it in the M365 License Portal.

  1. 1
    Save your file in OneDrive and open it in Excel for the web. Select your data, then Insert > Table with My table has headers selected. On Table Design, name it, for example Recipients.
  2. 2
    In Power Automate, select Create > Instant cloud flow, choose Manually trigger a flow, and select Create.
  3. 3
    Add List rows present in a table (Excel Online (Business)). Set Location to OneDrive for Business and Document Library to OneDrive, then choose your file and table.
  4. 4
    Add Send an email (V2) (Office 365 Outlook). Insert your email column in To; Power Automate adds a For each loop. Add columns to the subject and message.
  5. 5
    Inside the loop, add a Delay of 3 seconds after the email to stay under 30 messages a minute.
  6. 6
    More than 256 rows? In the settings of List rows present in a table, turn on Pagination and set a Threshold above your row count.
  7. 7
    Save, test with a table that contains only your address (Test > Manually > Run flow), then run it on your full table. Turn the flow off when you finish.

Sending from a shared or department mailbox? Use Send an email from a shared mailbox (V2) if you have permission to send from it. Microsoft explains the options in Create flows for popular email scenarios.

Gmail: mail merge with Google Sheets

 

If your KAUST email is on Gmail, you can merge straight from a Google Sheet, on any device with a browser.

  1. 1
    Put your responses on the first tab of a Google Sheet, with an email column and a first name column. Use text only, and check that headers and addresses have no special characters.
  2. 2
    In Gmail, select Compose. To the right of the To line, select Use mail merge and switch on Mail Merge.
  3. 3
    Select Add from a spreadsheet, choose your sheet, and select Insert. Choose the email and first name columns, then select Finish.
  4. 4
    Write your message. Type @ to insert a field from your sheet, such as the first name or session, and press Enter.
  5. 5
    Test with a copy of the sheet that contains only your own address. When it looks right, link the full sheet and send.
  6. 6
    Check your Sent folder. Each message shows a Sent with mail merge banner.

Good to know: fields do not work in the subject line or in linked text. Gmail adds an unsubscribe link to each message. You can send up to 1,500 mail merge messages a day, and attachments are copied into every message, so share a Google Drive link instead. Depending on how your account is set up, mail merge may be limited to KAUST addresses. If you do not see Use mail merge, contact KAUST IT.

Google guide: Send personalized emails with mail merge in Gmail.

Before you send: a quick checklist

 
  • Test with yourself
    Send to your own address first and read it on your phone too.
  • Check several records
    Look for blank fields, wrong columns, and names that display incorrectly.
  • One email per person
    Remove duplicates so nobody hears from you twice.
  • Do not flood one inbox
    Avoid sending many messages to the same address, such as a department inbox. Mailboxes also limit how much they can receive each hour.
  • Make replies easy
    Say who to contact and how. Replies come to the mailbox that sent the message.
  • Clean up
    Delete exports, test copies, and any flow you no longer need.

Troubleshooting

 

Windows: the merge finishes, but nothing is sent

Turn off the New Outlook toggle, make sure classic Outlook is open and signed in with your KAUST account, and check the Outbox before you try again, so you do not send twice.

macOS: Merge to E-mail is not available

Set Microsoft Outlook as the default email reader in Apple Mail settings, close the Excel file, then restart Word.

Gmail: I do not see Use mail merge

Mail merge depends on how your Google account is set up. Contact KAUST IT to check.

Gmail shows an error about a missing value

A row is missing a value for one of your fields. Enter a default value when Gmail asks, or fix the sheet.

Names show strange characters

Import the CSV again with UTF-8 encoding, check the names, and save the file before merging.

Dates or times look different in Word

Word can show the stored value of a date. Add a text column, for example =TEXT(A2,"d mmmm yyyy"), and merge that column instead.

Power Automate only emailed some of my list

List rows present in a table returns 256 rows unless you turn on Pagination. Check the run history before running again, so nobody gets a second message.

Power Automate asks for a premium license

The flow uses a premium connector or feature. The steps here need only standard connectors. If you need premium, see Requesting Microsoft 365 Licenses.

Messages are slow to arrive

That is the sending limit at work. Extra messages are held and sent over the following minutes. Let the merge finish before you try again.

Learn more

 

Handling response data: follow the Data Classification Policy and Procedure on the KAUST Policy Site. For a quick overview, read Your Data Has a Classification. Do You Know What It Is?