Hi
I wrote an access 2013 database serving our local community. We send out emails from the database on a monthly basis to members with their personalized statements. It works very well with much less administration than the previous attempts by others in Excel.
The community members use Telegram Messenger on their smart phones for various purposes. Now I received a request to adopt the database to send out summarized statements to Telegram Messenger on a frequent basis. We need to send out personalized messages based on data from the access database to the individual Telegram Messenger accounts of the members.
I searched the net with limited success. I am not a seasoned programmer / developer and thought along the following lines:
1. Create a BOT in Telegram Messenger (BOT = Telegram account without a mobile number that can send messages to Telegram accounts linked to a specific mobile phone number). I never created a bot before.
2. Create functionality in Access to send individual reports to the BOT to distribute to the member Telegram accounts. Not sure if this is just saving a HTML file somewhere and prompt the bot to send out the file.
These were just my thoughts and have not been tested / done before by myself.
Any advice on how to send a message from Access to Telegram Messenger will be appreciated.
I wrote an access 2013 database serving our local community. We send out emails from the database on a monthly basis to members with their personalized statements. It works very well with much less administration than the previous attempts by others in Excel.
The community members use Telegram Messenger on their smart phones for various purposes. Now I received a request to adopt the database to send out summarized statements to Telegram Messenger on a frequent basis. We need to send out personalized messages based on data from the access database to the individual Telegram Messenger accounts of the members.
I searched the net with limited success. I am not a seasoned programmer / developer and thought along the following lines:
1. Create a BOT in Telegram Messenger (BOT = Telegram account without a mobile number that can send messages to Telegram accounts linked to a specific mobile phone number). I never created a bot before.
2. Create functionality in Access to send individual reports to the BOT to distribute to the member Telegram accounts. Not sure if this is just saving a HTML file somewhere and prompt the bot to send out the file.
These were just my thoughts and have not been tested / done before by myself.
Any advice on how to send a message from Access to Telegram Messenger will be appreciated.