Send a message to Teams user through Excel VBA script

Reney Langlois 1 Reputation point
2022-09-23T16:02:24.313+00:00

Hi people,
I've been searching the Q/A and other areas for this and am suspecting it's not a trivial response. I know how to send an e-mail and a phone text message. I'd love to be able to send an MS Teams message through an Excel VBA script. FWIW, this would be for internal company correspondence. We're all on Outlook and use Teams extensively. I have a relatively simple macro in the production area that analyzes a product measurement I and want to provide a simple mechanism (ala button on the worksheet) for an operator to "ping" an engineer through a one-way canned Teams message due to it's visibility. The engineers would like this method of notification over e-mail or phone text.

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,478 questions
Microsoft Teams Development
Microsoft Teams Development
Microsoft Teams: A Microsoft customizable chat-based workspace.Development: The process of researching, productizing, and refining new or existing technologies.
2,837 questions