Aug 12 2021 05:49 AM
Aug 12 2022 09:32 AM
You can use use spreadsheets stored in Teams as your data source, and starting from Word, Mail merge will allow you to email via Outlook. Although starting from Word, you can choose to output to email. Easiest is to create a shortcut to OneDrive from the relevant folder in Teams (chain icon on folder), and then you can easily browse to the relevant files
Dec 08 2022 05:35 AM
@Vasil Michev Appreciate this is an old thread, but as it's the top result in Google with two apparently incorrect replies, I feel I should add to it.
The functionality for creating a mail merge is in Mircosoft Word, not Outlook. Therefore, we can't "use Outlook" alone.
Dec 08 2022 05:42 AM
@Colin1655 Each time I try to use a spreadsheet stored in MS Teams as the source for a mail merge, I get the error "the document name or path is not valid". Searching elsewhere suggests that a Web URL cannot be used.
Is there a part of this process that will make it into a local file path, please? I have a shortcut in One Drive, but I seem only able to get HTTPS links.