How to add multiple external email addresses from an excel spreadsheet to collect responses via Microsoft Forms?

Sandra White 20 Reputation points
2026-08-06T18:01:29.8933333+00:00

I want to send a survey that I have created on Microsoft Forms, to multiple external email addresses that I have on a spreadsheet?

Thank you

Microsoft 365 and Office | Microsoft Forms | For business
Answer accepted by question author
Ryan-N 15,565 Reputation points Microsoft External Staff Moderator
2026-08-06T18:12:17.9533333+00:00

Hi Sandra,

Welcome to the Microsoft Q&A forum.

To send a Microsoft Forms survey to multiple email addresses at once, you can follow these steps:

Step 1: Open your Microsoft Form, select Collect responses, choose Anyone can respond, and then copy the form link.

User's image

Step 2: Open Outlook and create a new email.

Step 3: Paste the form link into the body of the email.

Step 4: In the CC field, copy the entire column of email addresses from your Excel file and paste it into the field.

Step 5: Complete the email content and send it to the recipients.

 I hope this information is helpful. Please follow these steps and let me know if it works for you. If not, we can work together to resolve this.   

Thank you for your patience and your understanding. If you have any questions or need further assistance, please feel free to share them in the comments on this post so I can continue to support you.

I look forward to continuing the conversation.

If the answer is helpful, please click "Yes". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.  

Was this answer helpful?

2 people found this answer helpful.

1 additional answer

Sort by: Oldest
Most helpful Newest Oldest
  1. Muhammad Waqas Khan 80 Reputation points
    2026-08-11T18:34:48.7833333+00:00

    Hi Sandra,

    Great question! Sending a survey to many external contacts is a common need, and the approach really depends on how much control and tracking you need.

    Here are a few ways to do it, ordered from simplest to most robust:

    Microsoft Forms has a built-in feature to email the survey directly to individual recipients—and it automatically tracks who completed it.

    Open your form in Microsoft Forms.

    Click Collect responses.

    Under Send and collect responses, select Email.

    Enter each email address individually (or paste them in).

    Tip: You can paste a comma‑separated list, but there's a limit of about 100 addresses per send.

    Customize the email subject and message if needed.

    Click Send.

    Pros: Tracks who responded; each recipient gets a personalized link; no privacy issues.

    Cons: You'll need to send in batches if you have more than ~100 recipients.

    Option 2: Use Outlook with BCC (Better Than CC)

    If you prefer to send the link via Outlook, always use BCC (Blind Carbon Copy), not CC.

    In your form, click Collect responses and copy the link (set to Anyone with the link can respond if they're external).

    In Outlook, create a new email.

    Paste the form link into the email body.

    Paste your email list into the BCC field, not CC.
    (BCC hides all email addresses from each other.)

    Send it.

    Pros: Quick and easy; protects recipient privacy.

    Cons: You won't know who responded unless you add a "What's your email?" question to the form—which adds friction.

    Option 3: Mail Merge in Outlook (Best for Large Lists)

    If you have hundreds of recipients and want to personalize each email, use Outlook's Mail Merge with Excel.

    In your Excel spreadsheet, create a column for Email and optionally First Name, Company, etc.

    In Outlook, go to Mailings → Start Mail Merge → E‑mail Messages.

    Use the Excel file as your recipient list.

    Insert merge fields (like First Name) into the email body and the form link.

    Send the merge—Outlook will generate individual emails to each recipient.

    Pros: Personalizes each email; hides recipient lists; good for large volumes.

    Cons: Requires a bit more setup.

    Option 4: Power Automate (For Automation Nerds)

    If you do this frequently, automate it with Power Automate:

    Create a flow triggered by a manually uploaded Excel file.

    Loop through each row (email address).

    Use the Send an email (V2) action to send the form link.

    You can even add conditional logic (e.g., only send to certain segments).

    Pros: Fully automated; can track sends; integrates with other systems.

    Cons: Requires Power Automate licensing and setup time.

    Important Considerations

    Factor What to Do
    Privacy Use BCC or individual emails—never CC external lists.
    Limits Outlook typically allows ~500 recipients per email. Break larger lists into batches.
    Tracking Add a question like "Enter your email address" in the form if you need to map responses to individuals.
    Security If the survey contains sensitive info, set the form to Only people in my organization can respond and use Microsoft Entra guest accounts for external partners.

    My Recommendation

    For under 100 recipients → Use Forms' built‑in Email collect option (Option 1). It's clean and tracks responses.

    For 100–500 recipients → Use Outlook with BCC (Option 2) – fast and protects privacy.

    For 500+ or recurring sends → Set up a Power Automate flow (Option 4) to save time long‑term.

    Hope this helps you find the right fit for your needs! Let me know if you need step‑by‑step screenshots or help with any of these options.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.