Send & Receive Issues

How to Send Personalized Outlook Emails with Microsoft Forms Survey Links

Ayan Masood Oct 12, 2026 868 views

Question details

The user wants to send similar, personalized Outlook emails to multiple recipients, where each email contains a unique ticket number and a link to a Microsoft Forms survey.

How to Send Personalized Outlook Emails with Microsoft Forms Survey Links

Product: Microsoft Outlook, Microsoft Forms, Power Automate
Device & OS: not provided
Scenario: Distributing a Microsoft Forms survey link via Outlook while providing each recipient with their own unique ticket number for tracking or identification.
Observed behavior: Microsoft Forms does not have a built-in mail merge feature like Word or Outlook to automatically insert unique data fields (like ticket numbers) into outgoing survey invitations.

Before you start

Ensure you have access to Microsoft Power Automate through your Microsoft 365 account, and prepare an Excel spreadsheet hosted on OneDrive or SharePoint that contains your recipients' email addresses and their corresponding unique ticket numbers formatted as a Table.

Solution 1Recommended

Use Microsoft Power Automate to Create a Custom Mail Merge Flow

Since Microsoft Forms lacks a native mail merge tool, you can use Microsoft Power Automate to fetch data from an Excel spreadsheet and automatically send personalized Outlook emails containing the survey link and unique ticket numbers.

Power Automate connects different Microsoft services seamlessly. By linking an Excel table containing your contact list with the Outlook email connector, you can create a dynamic flow that iterates through each row of your spreadsheet, personalizing the email body for every single recipient.

Prepare Your Data Source

Create an Excel workbook on OneDrive or SharePoint. Add column headers for 'Email' and 'Ticket Number', fill in your recipient data, and format the data as an Excel Table (Insert > Table).

Create a New Flow

Log into Microsoft Power Automate. Click 'Create' from the left sidebar and select 'Instant cloud flow' (to trigger it manually) or 'Scheduled cloud flow' (to send at a specific time).

Retrieve Excel Data

Add a new action and search for 'Excel Online (Business)'. Select the 'List rows present in a table' action. Choose the location, document library, file, and the specific table you created in step 1.

Configure the Outlook Email Action

Add another action and search for 'Office 365 Outlook'. Select 'Send an email (V2)'. Power Automate will automatically place this inside an 'Apply to each' loop because it recognizes you are working with multiple rows of data.

Personalize the Email Content

Click into the 'To' field and select your 'Email' column from the dynamic content menu. In the email body, write your message, insert the 'Ticket Number' from the dynamic content where appropriate, and paste your Microsoft Forms survey link.

Test and Run Your Flow

Save the flow and click 'Test' in the upper right corner to run a manual test. Verify that the personalized emails are delivered to your test accounts successfully before running it for your full list.

Use Microsoft Power Automate to Create a Custom Mail Merge Flow

Community Support Available: Building flows can sometimes require troubleshooting specific connectors. If you encounter errors, the Microsoft Power Platform community forums (powerusers.microsoft.com) are highly active and provide specialized help for Power Automate.

Free Microsoft Office alternative

Need a Simpler Way to Perform Mail Merges? Try WPS Office

If configuring Microsoft Power Automate flows seems too complex for sending personalized emails, WPS Office offers a straightforward, built-in Mail Merge feature. As a free, lightweight, and highly compatible alternative to Microsoft Office, WPS allows you to seamlessly merge spreadsheet data into personalized emails directly from its familiar word processor interface.

1. Open WPS Writer: Launch WPS Writer and draft the email template you want to send to your recipients, including placeholders for your unique ticket numbers.
2. Connect Your Spreadsheet: Navigate to the 'References' tab, click 'Mail Merge', select 'Open Data Source', and choose the WPS Spreadsheet containing your emails and ticket data.
3. Merge to Email: Insert the dynamic merge fields into your document, then click the 'Merge to Email' button to instantly send customized emails to your entire list.

Seamlessly compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Built-in, easy-to-use Mail Merge feature for sending personalized batch emails.Lightweight suite that installs quickly without slowing down your computer.Free to use with a highly familiar user interface, requiring zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Can I use standard Outlook Mail Merge to include Microsoft Forms links?

Yes, if you only need a generic survey link, you can use the traditional Mail Merge feature within Microsoft Word and Outlook. You can still use dynamic fields for the ticket numbers, but the survey link will remain the same for everyone.

Is Power Automate free to use for automating Outlook emails?

Power Automate includes a free tier that comes standard with most Microsoft 365 personal, educational, and business subscriptions. This tier provides enough monthly flow runs to easily handle standard email automation and mail merge tasks.

Can I track who completed the survey based on the ticket number?

Yes. If you instruct users to manually enter their unique ticket number into a specific question on the Microsoft Form, you can later cross-reference the survey responses in Excel with your original ticket number list to see who has replied.

Why isn't the 'Send an email (V2)' action working in my flow?

This usually happens if your Office 365 Outlook connection needs to be re-authenticated, or if you did not format your source data as a proper Table in Excel. Ensure your Excel file has a Table applied and check your connection status in Power Automate.

Outlook & Email Problems