Insert Excel Tables and Charts into Email Body

Q: I have an Excel report. I want to display the report and its charts in the body of an email. How can I achieve this?

A: You can insert this table into the body template in SQLMessenger.

September 15, 2024

How to send emails to different recipients based on the date

Q: I have a duty engineer roster like the one below. I want to send system alert messages to the engineer on duty for each day based on the date. For example, send alert emails to Liam on Monday, to Noah on Tuesday, and so on. How should I configure this?

A: You can use the "Variable Recipient" of SQLMessenger to accomplish this task.

September 06, 2024

How to send a message to Slack workspace members using an SQL statement

Q: How to send a message to Slack workspace members using an SQL statement?

A: You can use the "External Interface" feature of SQLMessenger to achieve this function. This method supports PostgreSQL, MySQL, SQL Server, Oracle, and Informix databases.

September 05, 2024

How to automatically and regularly send reports to colleagues

Q: I am a database administrator. I need to send some reports to my colleagues every week. I want to automate this process. How should I do it? Specifically, I would like to send the following report every Monday and on the last day of each month.

A: Yes. SQLMessenger can help you easily achieve these functions. Here are the detailed steps.

September 05, 2024

Send Reminder to Employees When Tasks Are Due

Q: Good day, I created a task distribution list. I would like to automatically send an email reminder if a task is due. The email reminder has to be the date when is due. The deadline or due date would be in Column C. The data is in an Excel table. Thank you in advance.

A: Yes. You can use the "Task Reminder" program in SQLMessenger to achieve this functionality.

September 04, 2024

Auto Start SQLMessenger when the System Starts Up

After SQLMessenger is installed, it does not start automatically. You can configure it to start automatically with the operating system in the System Settings dialog.

August 19, 2024

Automatically Fill in Excel Sheets Using SQLMessenger

In SQLMessenger, you can create an Excel template and have SQLMessenger fill the query results from SQL statements into the specified cells in the template, thereby achieving automatic filling of Excel sheets. This article introduces how to use the automatic Excel sheet filling feature through a simple example.

July 06, 2024

Using Task Schedules

In SQLMessenger, you can configure Task Schedules to specify when the system should automatically start the task. You can configure multiple schedules for a task to start it at different times.

June 26, 2024

Demo Task - Email Distribution

This task is used to distribute the records in an Excel spreadsheet to each recipient. You can edit the email subject and body in the Excel spreadsheet, and then SQLMessenger will send the emails to the recipients.

June 23, 2024

Demo Task - Sales Report Distribution

To assist you in understanding the configuration method for the information distribution function of SQLMessenger, after the system installation is complete, you can find a task named "(Demo) Sales Report Distribution" on the MainPage.

June 23, 2024