How to Add Outlook Address Book Autocomplete to Microsoft Forms
Question details
The user wants to connect a Microsoft Forms field to the Outlook address book to provide automatic email address suggestions for respondents.

- Product
- Microsoft Forms
- Device & OS
- not provided
- Scenario
- Creating a form or survey where respondents need to input email addresses, ideally leveraging the organization's existing directory for auto-completion.
- Observed behavior
- Microsoft Forms currently lacks a built-in feature to link text fields to the Outlook address book or Global Address List (GAL) for directory lookup and autocomplete.
Keep in mind that Microsoft Forms is designed for simple, lightweight data collection and currently does not support advanced live data lookups from Exchange or Outlook directories.
Build a Custom Form with Microsoft Power Apps
If directory lookup and autocomplete functionality are strict requirements for your form, you should transition from Microsoft Forms to Microsoft Power Apps.
Microsoft Power Apps is a more robust solution within the Microsoft 365 ecosystem. It allows you to build custom canvas apps that can connect directly to the Office 365 Users directory, enabling intelligent auto-complete functionality for email addresses inside your organization.
Log into your Microsoft 365 portal, open the app launcher (waffle icon), and select Power Apps.
Click 'Create' from the left menu and choose to build a Blank Canvas App. Give your app a name and select a layout.
Navigate to the Data tab on the left panel, select 'Add data', and search for 'Office 365 Users'. Click it to connect the directory to your app.
Go to the 'Insert' tab and add a 'Combo box' to your screen. In the properties panel on the right, set its 'Items' property to search the Office 365 Users directory. This will enable the autocomplete feature when users start typing a name or email.

Use a Standard Text Field for Email Collection
If you prefer to stay within Microsoft Forms, the simplest workaround is to use a standard text question and clearly instruct users to provide their full email address.
Switch to WPS Office for Efficient Form Data Processing
While Microsoft Forms is great for basic surveys, managing the exported email addresses and response data often requires a powerful spreadsheet tool. WPS Office provides a lightweight, comprehensive, and highly compatible alternative to Microsoft Office. With WPS Spreadsheet, you can easily process, filter, and apply data validation to the email addresses collected from your forms without heavy subscription fees.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install the Suite: Run the downloaded installer and follow the simple on-screen prompts to set up the software.
- 3. Manage Form Responses: Export your Microsoft Forms data as an Excel file and open it instantly in WPS Spreadsheet to begin organizing your collected emails.

Frequently Asked Questions
Can I automatically collect respondent email addresses without asking them in Microsoft Forms?
Yes, if the respondents are within your organization. In the Form settings, choose 'Only people in my organization can respond' and check the 'Record name' box. This will automatically capture their name and associated email address upon submission without needing an autocomplete field.
Does Microsoft Forms support custom scripts to add an autocomplete feature?
No, Microsoft Forms is a closed platform that does not support adding custom JavaScript, HTML, or external APIs to modify form behavior. You cannot code a custom autocomplete field into it.
Where can I request Microsoft to add the Outlook autocomplete feature to Forms?
You can submit feature requests directly to Microsoft through the Microsoft Forms feedback forum. Access it by clicking the 'Help' or 'Feedback' icon usually located in the bottom right corner or the top menu of the Forms interface.




