How can I use VBA from an Excel spreadsheet to create a new chat in MS Teams?
Using VBA in Excel, I can send emails via MS Outlook to specific users. This works fine using VBA constructs like "CreateObject("Outlook.Application"), ".CreateItem(0)" and "created item.Send" for example. Our organisations wishes to embrace MS teams, so I need to be able to do the equivalent, that is cerate an MS teams application and chat instance, then compose the chat and "send" it. Rather than specifying an email address, I think I would specify a chat address of the form "@ user name", but that's as far I can figure out.