Note: Calculated fields can only operate on their own row, so you can't reference a value in another row, or columns contained in another list or library.Lookup fields are not supported in a formula, and the ID of newly inserted row can't be used as the ID doesn't exist when the formula is processed.

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.

Training: Watch and learn how to create a PowerPoint presentation, add/format text, and add pictures, shapes, and/or charts.

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.

If you can access a file on your device, you can share the file with other people in Teams. This includes files (of any type) that are on the Files tab of your channels and chats, in your OneDrive or other cloud storage, and on your local device. Send the file itself or send a link to the file.

In the Office Add-ins box, select My Add-ins to view your add-ins. Or browse for the add-in you want by selecting Store tab and using the Search box. Click an add-in to read more about it, including a longer description and customer reviews, if available.

If you choose the Do Not Forward option, there are two possibilities:. Microsoft Office attachments such as Word, Excel or PowerPoint files remain encrypted even after they’re downloaded. This means that if the recipient downloads the attachment and sends it to someone else, the person they forwarded it to won’t be able to open the attachment because they don’t have permission to open it.

In Windows 10, action center is where you'll find your app notifications and quick actions—which give you quick access to commonly used settings and apps.

Browse on the go with the new Microsoft Edge for Android and iOS devices. Microsoft Edge offers better protection and privacy, and can sync your favorites, passwords, and more across your desktop and mobile devices.

In the Insert Object box, select Create from file, and then enter the PDF file location; or select Browse, find the PDF file, and then select OK.. This makes the PDF file part of the presentation file. The quality of the PDF file is reduced with this method, but you can open the full PDF file by double-clicking the image when viewing or editing in Normal view.