Data sources. Your first step in setting up a mail merge is to pick the source of data you'll use for the personalized information. Excel spreadsheets and Outlook contact lists are the most common data sources, but if you don't yet have a data source, you can type it up in Word, as part of the mail merge process.

Add your Outlook.com, Microsoft 365, or Exchange-based email account to your iPhone, iPad, or iPod Touch using the iOS Mail app.

Note: Before selecting New, consider selecting the check box for "Prompt a profile to be used."If this is enabled, you will get a prompt every time you start Outlook to pick which profile you want to open. This is helpful when you have multiple profiles and need to switch between them.

Vector form. The vector form of LOOKUP looks in a one-row or one-column range (known as a vector) for a value and returns a value from the same position in a second one-row or one-column range.. Syntax. LOOKUP(lookup_value, lookup_vector, [result_vector]) The LOOKUP function vector form syntax has the following arguments:. lookup_value Required.A value that LOOKUP searches for in the first vector.

Important: Apps for Office have a new name: Office Add-ins.We are currently updating our products, documentation, samples, and other resources to reflect the platform name change from "apps for Office and SharePoint" to "Office and SharePoint Add-ins".

Depending on the length of the video, generating closed captions can take several minutes. Once generated, you can watch the video in Stream and have captions displayed at the bottom of the screen.. When the caption have been created, the Generate button turns to Translate.Select Translate to change the spoken or screen language to automatically translate the captions.

Updated Files On-Demand settings on Windows.We are updating the OneDrive sync app advanced settings for Files On-Demand for users who have the feature enabled.

With External Access for Teams, you can add or invite anyone outside of your Teams org who uses Teams, Teams for personal use, Skype (for consumers), and Skype for Business to a one-to-one chat.

Note: If you have a current version of Microsoft 365, then you can input the formula in the top-left-cell of the output range, then press ENTER to confirm the formula as a dynamic array formula. Otherwise, the formula must be entered as a legacy array formula by first selecting the output range, input the formula in the top-left-cell of the output range, then press CTRL+SHIFT+ENTER to confirm it.

Learn how to download, install, and configure Language Accessory Packs for Microsoft 365 for additional display, help, and proofing tools.