AndySqlman articles - 23 total
Automating Secure Invoice Delivery with AttachmentMailerTool
Automating Secure Invoice Delivery with AttachmentMailerTool Every month, I need to send...
Automating SQL Reports Without Power BI or SSRS: A Lightweight Alternative
Tired of heavyweight BI tools like Power BI or SSRS for scheduled SQL reporting? Discover...
Automatically merge Excel tables and generate statistical reports using SQLMessenger
Q: I receive several (dozens of) Excel files every day. My job is to consolidate these...
Sending Telegram Messages via SQL Statements
How to send telegram messages in SQL statements? SQLTelebot (also known as Telebot) is a plugin for...
Sending Personalized Telegram Messages in Bulk
Q: We've sent small birthday gifts to some of our customers. I've created a table as shown...
Forward Telegram Messages to Email
How to automatically forward Telegram messages to a specific email address? SQLTelebot (also known...
Automatically Forward New Emails to Telegram
How to forward different emails to different Telegram groups (or contacts) upon receiving new...
How to automate saving and merging daily Excel files into a master spreadsheet?
Reposted From https://www.sqlmessenger.com/faqview.html?id=576 Q: Some colleagues send me...
How to import data from CSV files attached in emails automatically?
Reposted from https://www.sqlmessenger.com/faqview.html?id=571 Q: Automatically import data...
Automating Excel Report Processing from Email Attachments
Reposted From: https://www.sqlmessenger.com/faqview.html?id=569 Q: Hi All, I have an excel report...
Automatically convert the records in an Excel sheet into images and automatically send them individually to each instructor
Reposted From: https://www.sqlmessenger.com/faqview.html?id=567 Q: I need to convert the records in...
How to insert Excel tables and charts into email body
Reposted From: https://www.sqlmessenger.com/docreader.html?id=562 Q: I have an Excel...
How to send reports to different recipients based on the date
Reposted from https://www.sqlmessenger.com/docreader.html?id=559 Q: I have a duty engineer...
How to display an SQL query result in email body
Reposted from: https://www.sqlmessenger.com/faqview.html?id=557 Q: I have the following...
How to send a message to Slack workspace members using an SQL statement
Reposted from https://www.sqlmessenger.com/docreader.html?id=556 Q: How to send a message...
How to automatically and regularly send reports to colleagues
Reposted from https://www.sqlmessenger.com/docreader.html?id=555 Q: I am a database...
Automatically import excel attachment data into local database upon receiving an email
Reposted from https://www.sqlmessenger.com/docreader.html?id=553 Q: I want to automatically...
Send reminder to employees when tasks are due
Reposted from: https://www.sqlmessenger.com/docreader.html?id=552 Q: Good day, I created a...
How to send PDF files to each recipient individually
Reposted from https://www.sqlmessenger.com/faqview.html?id=545 Q:How to Quickly Distribute...
Configuring Gmail or Yahoo mail accounts in SQLMessenger
After SQLMessenger is installed, we need to configure email accounts within it for sending emails....
Display Excel spreadsheet with graphics in the body of an email
Q: I have a completed Excel spreadsheet (such as the one below). Can I display this...
How to build an order monitoring system on your own
Q: I have many orders stored in my CRM database. I need to frequently (possibly daily or...
How to automatically filling excel sheets with SQL query results
Q: I need to populate a table with the results of SQL queries like the one below every day....