Telegram Bot

Here’s a vb script snippet that I have used to send Telegram message in a group from an Excel sheet. Sub sendTelegramMessage() Set objHttp = CreateObject("MSXML2.ServerXMLHTTP") ' Change these accordingly strChat = "<chat_id>" strText = "*Test*\r\nThis is a message" strUrl = "https://api.telegram.org/bot<token>/sendMessage" ' Leave these alone strMode = "markdown" strJson = "{""chat_id"": """ & strChat & """, ""text"": """ & strText & """, ""parse_mode"": """ & strMode & """}" objHttp.Open "POST", strUrl, False objHttp.setRequestHeader "Content-type", "application/json" objHttp.send strJson End Sub

Talk to @BotFather, and request to create a new bot. (hint: /help) Give the new bot a name, and a unique username. Take note of the bot token given by the @BotFather Add the new bot to a group. Run this - https://api.telegram.org/bot<bot_token>/getUpdates , to get the group’s chat id that contains the new bot. In the group, type /start @username to activate the new bot.