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.
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.
All three can collect responses and email you about them. They differ most in how much you can customize what people receive.
| Microsoft Forms | Google Forms | Formstack | |
|---|---|---|---|
| Who can use it at KAUST | Everyone with a KAUST Microsoft 365 account | Everyone with a KAUST Google account | Formstack license holders |
| Email to you when someone responds | Yes | Yes | Yes, to you, your team, or routed recipients |
| Email to the person who responded | A receipt of their answers | A copy of their response | Up to three confirmation emails |
| Write your own email message | Not built in. Use Power Automate. | Not built in | Yes, with fields from the response |
| Thank-you message on screen | Yes | Yes | Yes, with fields from the response |
| Redirect to a web page after submitting | No. Add a link in the thank-you message. | No. Add a link in the confirmation message. | Yes |
| Responses in a spreadsheet | Open in Excel | Link to Google Sheets, or download a CSV | Export to Excel or CSV |
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:
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.
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
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 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 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.
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.
FirstName, Email, and Session. All three tools use each question as a header, so a header can be a full sentence.Session and use =TEXTJOIN(", ",TRUE,C2:J2) to bring the filled-in value into one cell, then fill it down.What to expect in each export
| Tool | Columns you will usually see | Watch for |
|---|---|---|
| Microsoft Forms | ID, Start time, Completion time, Email, Name, then one column per question | Name and email are filled in only when people sign in with a KAUST account. Otherwise ask for them in a question. |
| Google Forms | Timestamp, Email Address if you collect it, then one column per question | Gmail mail merge cannot read headers with special characters, so rename question headers. |
| Formstack | Time, Name (First), Name (Last), Email, Unique ID, plus Browser, IP Address, Location | Hide the browser, IP address, and location columns before exporting. Use Unique ID as a reference number. |
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.
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.
FirstName, or Greeting Line for the greeting.Word uses the same subject line for everyone and cannot add attachments or Cc. Put links in the message instead of attaching files.
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.
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.
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.
Recipients.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.
If your KAUST email is on Gmail, you can merge straight from a Google Sheet, on any device with a browser.
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.
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.
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?